Developing a Master Budget for a Manufacturing Organization Cubs Incorporated ma
ID: 2575343 • Letter: D
Question
Developing a Master Budget for a Manufacturing Organization
Cubs Incorporated manufactures a product with a selling price of $60 per unit. Units and monthly cost
data follow:
Variable:
Selling and administrative . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .$5 per unit sold
Direct materials. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12 per unit manufactured
Direct labor. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12 per unit manufactured
Variable manufacturing overhead. . . . . . . . . . . . . . . . . . . . . . . . . . .6 per unit manufactured
Fixed:
Selling and administrative . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .$17,000 per month
Manufacturing (including depreciation of $11,000). . . . . . . . . . . .34,000 per month
Cubs Inc. pays all bills in the month incurred. All sales are on account with 50 percent collected the month
of sale and the balance collected the following month. There are no sales discounts or bad debts.
Cubs Inc. desires to maintain an ending finished goods inventory equal to 20 percent of the follow-
ing month’s sales and a raw materials inventory equal to 10 percent of the following month’s produc-
tion. January 1, 2017, inventories are in line with these policies.
Actual unit sales for December and budgeted unit sales for January, February, and March of 2017
are as follows:
CUBS INCORPORATED
Sales Budget
For the Months of January, February, and March 2017
Month December January February March
Sales—Units........................11,250 10,000 15,000 13,000
Sales—Dollars ......................$675,000 $600,000 $900,000 $ 780,000
Additional information:
• The January 1 beginning cash is projected as $6,000.
• For the purpose of operational budgeting, units in the January 1 inventory of finished goods are
valued at variable manufacturing cost.
• Each unit of finished product requires one unit of raw materials.
• Cubs Inc. intends to pay a cash dividend of $12,000 in January
Required
a. A production budget for January and February.
b. A purchases budget in units for January.
c. A manufacturing cost budget for January.
d. A cash budget for January.
e. A budgeted contribution income statement for January.
Explanation / Answer
Per Chegg guidelines, 4 sub-parts have been answered.
a. Cubs Incorporated Production Budget For the Months of January and February January February March Budgeted sales in units 10000 15000 13000 Desired ending FG inventory as percent of following month's budgeted sales (units) 20% 20% Budgeted ending inventory (units) 3000 2600 Required production (units) 13000 17600 Beginning inventory (units) 2000 3000 Budgeted production in units 11000 14600 b. Cubs Incorporated Purchases Budget For the Month of January January February Budgeted production in units 11000 14600 Material required per unit of production 1 1 Materials needed for production 11000 14600 Desired ending Raw Materials inventory as percent of following month's production requirement 10% Budgeted ending inventory (units) 1460 Total DM required (units) 12460 Beginning inventory (units) 1100 Materials to be purchased (units) 11360 c. Cubs Incorporated Manufacturing Cost Budget For the Month of January Varible costs: Direct materials (11000 x $12) 132000 Direct labor (11000 x $12) 132000 Manufacturing overhead (11000 x $6) 66000 Total variable costs 330000 Fixed costs: Manufacturing overhead 34000 Total manufacturing cost $ 364000 d. Cubs Incorporated Cash Budget For the Month of January Beginning cash balance, January 1 6000 Add collections from customers: For December sales ($675000 x 50%) 337500 For January sales ($600000 x 50%) 300000 Total collections from customers 637500 Total cash available 643500 Less cash disbursements: Variable Manufacturing costs 330000 Fixed manufacturing costs ($34000 - $11000 depreciation) 23000 Variable Selling and administrative expenses (10000 x $5) 50000 Fixed selling and administrative expenses 17000 Dividends paid 12000 Total cash disbursements 432000 Ending cash balance $ 211500Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.