Question

In: Accounting

5-10 Preparing a production budget (CMA adapted) (LO 3) Rossano, Inc., makes and sells drum sets....

5-10 Preparing a production budget (CMA adapted) (LO 3)

Rossano, Inc., makes and sells drum sets. Nick Ross, controller, is responsible for preparing the master budget. The sales manager has given Nick the following sales forecast for the coming months.

April

May

June

July

Forecasted unit sales

12,000

15,000

10,000

11,000

Rossano expects to have 6,000 drum sets in ending inventory on March 31. The company’s policy is to carry 30% of the following month’s projected sales in ending inventory.

Required

Prepare Rossano’s production budget for the second quarter.

Solutions

Expert Solution

Production budget:
Particulars April May June
Sales in units                       12,000                       15,000                       10,000
Add
Closing inventory                         4,500                         3,000                         3,300
15000*10% 10000*10% 11000*10%
Total needs                       16,500                       18,000                       13,300
Less
Opening inventory 6000                         4,500                         3,000
Production for the month                       10,500                       13,500                       10,300

Related Solutions

Patrick Inc. makes industrial solvents sold in 5-gallon drum containers. Planned production in units for the...
Patrick Inc. makes industrial solvents sold in 5-gallon drum containers. Planned production in units for the first 3 months of the coming year is: January 40,000 February 50,000 March 65,000 Each drum requires 6 gallons of chemicals and one plastic drum container. Company policy requires that ending inventories of raw materials for each month be 20% of the next month's production needs. That policy was met for the ending inventory of December in the prior year. The cost of one...
Optimal product mix. (CMA adapted) Della Simpson, Inc., sells two popular brands of cookies: Della’s Delight...
Optimal product mix. (CMA adapted) Della Simpson, Inc., sells two popular brands of cookies: Della’s Delight and Bonny’s Bourbon. Della’s Delight goes through the Mixing and Baking departments, and Bonny’s Bourbon, a filled cookie, goes through the Mixing, Filling, and Baking departments. Michael Shirra, vice president for sales, believes that at the current price, Della Simpson can sell all of its daily production of Della’s Delight and Bonny’s Bourbon. Both cookies are made in batches of 3,000. In each department,...
E5-14 Determining Cost Behavior, Preparing Contribution Margin Income Statement [LO 5-1, 5-5] Riverside Inc. makes one...
E5-14 Determining Cost Behavior, Preparing Contribution Margin Income Statement [LO 5-1, 5-5] Riverside Inc. makes one model of wooden canoe. Partial information for it follows: Number of Canoes Produced and Sold 530 680 830 Total costs Variable costs $ 78,440 ? ? Fixed costs 149,300 ? ? Total costs $ 227,740 ? ? Cost per unit Variable cost per unit ? ? ? Fixed cost per unit ? ? ? Total cost per unit ? ? ? Required: 1. Complete...
E5-14 Determining Cost Behavior, Preparing Contribution Margin Income Statement [LO 5-1, 5-5] Riverside Inc. makes one...
E5-14 Determining Cost Behavior, Preparing Contribution Margin Income Statement [LO 5-1, 5-5] Riverside Inc. makes one model of wooden canoe. Partial information for it follows: Number of Canoes Produced and Sold 455 605 755 Total costs Variable costs $ 66,430 ? ? Fixed costs 148,100 ? ? Total costs $ 214,530 ? ? Cost per unit Variable cost per unit ? ? ? Fixed cost per unit ? ? ? Total cost per unit ? ? ? Required: 1. Complete...
Problem 16-10 Calculating Cash Collections [LO 3] The following is the sales budget for Segura, Inc.,...
Problem 16-10 Calculating Cash Collections [LO 3] The following is the sales budget for Segura, Inc., for the first quarter of 2013: January February March   Sales budget $138,000 $151,000 $163,000 Credit sales are collected as follows: 65 percent in the month of the sale 20 percent in the month after the sale 15 percent in the second month after the sale The accounts receivable balance at the end of the previous quarter was $94,000 ($69,000 of which was uncollected December...
Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single...
Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single product at a price of $25 per unit. Sales (in units) are forecasted at 41,000 for January, 61,000 for February, and 51,000 for March. Cost of goods sold is $12 per unit. Other expense information for the first quarter follows. Commissions 9 % of sales dollars Rent $ 18,000 per month Advertising 13 % of sales dollars Office salaries $ 72,000 per month Depreciation...
A company makes and sells a single product, the variable cost of the production is $3...
A company makes and sells a single product, the variable cost of the production is $3 per unit and variable cost of selling is $1 per unit, fixed cost totalled $600, and the selling price per unit was $6. The company budgeted to make and sell 3 000 units in the next year. Required Prepare a break even chart showing the expected amount of the output and sales required to break even.
5-24 Preparing a cash payments budget (LO 4) Dakota Williams is one of Texas’s premiere party...
5-24 Preparing a cash payments budget (LO 4) Dakota Williams is one of Texas’s premiere party planners. She purchases a variety of supplies, such as plastic tableware, stemware, and decorations, throughout the year. Dakota has prepared the following purchases budget for the coming year. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted purchases $300,000 $420,000 $435,000 $515,000 Historically, Dakota has paid for 40% of her purchases in the quarter of purchase and 60% in the quarter following purchase. On...
Exercise 14-13 Preparing a cash budget LO 14-5 The accountant for Rooney’s Dress Shop prepared the...
Exercise 14-13 Preparing a cash budget LO 14-5 The accountant for Rooney’s Dress Shop prepared the following cash budget. Rooney’s desires to maintain a cash cushion of $17,000 at the end of each month. Funds are assumed to be borrowed and repaid on the last day of each month. Interest is charged at the rate of 3 percent per month. Required Complete the cash budget by filling in the missing amounts. Determine the amount of net cash flows from operating...
Exercise 20-34 Budgeted income statement LO P3 Fortune, Inc., is preparing its master budget for the...
Exercise 20-34 Budgeted income statement LO P3 Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single product at a price of $25 per unit. Sales (in units) are forecasted at 37,000 for January, 57,000 for February, and 47,000 for March. Cost of goods sold is $12 per unit. Other expense information for the first quarter follows. Commissions 11 % of sales dollars Rent $ 22,000 per month Advertising 14 % of sales dollars...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT