Heart & Soul expects to sell 20,00 CDs in the first 4 months of 20X1. Each...

Heart & Soul expects to sell 20,00 CDs in the first 4 months of 20X1. Each CD sells for $12 and costs $8. Operating budget for Q1 are projected as follows:

20X1	January	February	March	April
Expected sales (in Units)	2,500	4,000	7,500	6,000

a) Prepare a monthly sales forecast in dollars for Q1 (January, February and March)

b) Prepare a monthly contribution margin statement for Q1

Assuming that Heart & Soul ending inventory is projected to be 80% of next month sales. Company started 20X1 with 2,000 CDs in inventory.

c) How many CDs does the company need to buy each month of Q1?

d) What is the cost of inventory purchases for each month?

Solutions

Expert Solution

Monthly Sales Forecast (in $) = Expected Sales * Selling Price

	January	February	March
Monthly Sales Forecast (in $)	30000	48000	90000

Monthly Contribution Margin = Monthly Sales Forecast (in $) – Variable costs

Contribution Margin (%) = (Contribution Margin/Monthly Sales Forecast (in $)) * 100

	January	February	March
Monthly Sales Forecast	30000	48000	90000
Variable Cost	20000	32000	60000
Contribution Margin	10000	16000	30000
Contribution Margin (%)	33.33%	33.33%	33.33%

CDs the company need to buy each month = Closing Balance for the month + Monthly Sales – Opening Balance for the month

Opening Balance for January is given in the question as 2000

Closing balance of each month can be calculated as 80% of expected sales of next month

	January	February	March
Monthly Sales Forecast	30000	48000	90000
Opening Inventory	2000	3200	6000
Closing Inventory	3200	6000	4800
CDs company need to buy	3700	6800	6300

Cost of Inventory Purchased = CDs company need to buy * cost of each CD

	January	February	March
CDs company need to buy	3700	6800	6300
Cost of each CD	8	8	8
Cost of Inventory Purchased	29600	54400	50400

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects...

Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects the following unit sales: January 41,000 February 38,000 March 50,000 April 51,000 Patrick's policy is to have 25% of next month's sales in ending inventory. On January 1, it is expected that there will be 6,700 drums of solvent on hand. Required: Prepare a production budget for the first quarter of the year. Show the number of drums that should be produced each month...

Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects...

Patrick Inc. makes industrial solvents. In the first 4 months of the coming year, Patrick expects the following unit sales: January 41,000 February 38,000 March 50,000 April 51,000 Patrick's policy is to have 23% of next month's sales in ending inventory. On January 1, it is expected that there will be 4,500 drums of solvent on hand. Required: Prepare a production budget for the first quarter of the year. Show the number of drums that should be produced each month...

First Class, Inc., expects to sell 29,000 pool cues for $13 each. Direct materials costs are...

First Class, Inc., expects to sell 29,000 pool cues for $13 each. Direct materials costs are $3, direct manufacturing labor is $5, and manufacturing overhead is $0.83 per pool cue. The following inventory levels apply to 2019: Beginning inventory Ending inventory Direct materials 24,000 units 24,000 units Work-in-process inventory 0 units 0 units Finished goods inventory 1,200 units 2,800 units What are the 2019 budgeted costs for direct materials, direct manufacturing labor, and manufacturing overhead, respectively?

A cattle farmer expects to have 120,000 pounds of live cattle to sell in three months....

A cattle farmer expects to have 120,000 pounds of live cattle to sell in three months. The live-cattle futures contract traded by the CME Group is for the delivery of 40,000 pounds of cattle. How can the farmer use the contract for hedging? From the farmer’s viewpoint, what are the pros and cons of hedging?

A company expects to sell 6,000 units in April and expects sales to increase 20% each...

A company expects to sell 6,000 units in April and expects sales to increase 20% each month after. The unit sales price of $8 is expected to remain constant. The company wants ending finished goods inventory to be 15% of the next month’s sales. What are budgeted sales revenues for the second quarter? How many units will be produced in the second quarter? Round answers to nearest whole number. The raw materials ending inventory should be 20% of the next...

4. If a company expects to sell 4,500 units, has a DOL of 2 and a...

4. If a company expects to sell 4,500 units, has a DOL of 2 and a % change in Operating Cash Flow of 22% (positive), how many units did they actually sell? a. 400 b. 440 c. 4,440 d. 4,995 e. None of the above 5. Which of the following is FALSE about the efficient markets hypothesis? a. EMH implies that the market has already incorporated characteristics such as dividend policy into its price. b. EMH is the idea that actual capital markets, such as the NYSE, are...

We consider a European right to sell to expire in 4 months. The right is written...

We consider a European right to sell to expire in 4 months. The right is written in a share that does not pay a dividend, the current price of which is 64 euros. It is given that the exercise price is 60 euros and the interest rate without risk is 12% (on an annual basis). Examine if there is an arbitrage opportunity and if there is to show in detail the steps required to achieve it.

The manager at Tom's Taxidermy expects to sell 900 units at $80 each unit. In order...

The manager at Tom's Taxidermy expects to sell 900 units at $80 each unit. In order for the manager to breakeven, the manager must sell 100 units. What is the margin of safety in dollars? $72,000 $79,000 $80,000 $64,000

A toy manufacturer expects to sell 4536 games in a year. The games cost $20 each...

A toy manufacturer expects to sell 4536 games in a year. The games cost $20 each plus a fixed delivery cost of $140 per order. If it cost $5 to store a game for a year, find the order size and the number of orders that minimizes inventory costs.

Here is a forecast of sales by National Bromide for the first 4 months of 2019...

Here is a forecast of sales by National Bromide for the first 4 months of 2019 (figures in thousands of dollars): Month: 1 2 3 4 Cash sales 25 34 28 24 Sales on credit 150 170 140 120 On average, 50% of credit sales are paid for in the current month, 30% in the next month, and the remainder in the month after that. What are the expected cash collections in months 3 and 4? (Enter your answers in...

Subjects