Cellular Solutions,Inc MrSerene,vice President of Sales,is Preparing the Sales Budget for 2010

question 64

Essay

Cellular Solutions,Inc.,had a very successful year in 2009.Based on a $100 average unit selling price,monthly sales during 2009 were as follows:
$\begin{array}{|lr|}\hline \text { January } & \$ 80,000 \\\text { February } & 70,000 \\\text { March } & 90,000 \\\text { Apri } & 70,000 \\\text { May } & 60,000 \\\text { June } & 50,000 \\\text { July } & 50,000 \\\text { August } & 60,000 \\\text { September } & 65,000 \\\text { October } & 75,000 \\\text { November } & 85,000 \\\text { December } & 95,000 \\\text { Total } & \$ 850,000 \\\hline\end{array}$
Mr.Serene,vice president of sales,is preparing the sales budget for 2010.Increased manufacturing costs will make it necessary to increase the selling price by 10 percent.Even with this price increase,the unit volume of sales is expected to increase by 20 percent.The seasonal sales pattern shown for 2009 is expected to continue in 2010.
a. Prepare the monthly sales unit and dollar budgets for the first quarter of 2010.
b. Mr. Serene is considering the possibility of raising the average selling price by 30 percent in 2010. If this action is taken, he projects that the sales volume for the year will increase by only 12 percent. What would forecasted sales in units and dollars be in 2010 if his projection is correct?

---

Definitions:

Demand Curves

An illustration that depicts the relationship between the price of an item and the quantity demanded by consumers, typically downward sloping.

Range P₁P₂

The difference in price levels denoted as P₁ and P₂, often used to describe a price range in economic analysis.

Beef Demanded

The quantity of beef consumers are willing and able to purchase at a given price within a specified time period.

Price Increase

A rise in the cost of goods or services, affecting consumption patterns and inflation rates.