Developing a Master Budget
for a Manufacturing Organization
Jacobs Incorporated manufactures a product with a selling price of
$50 per unit. Units and monthly cost data follow:
Variable: | |
Selling and administrative |
$5 per unit sold |
Direct materials | 10 per unit manufactured |
Direct labor | 10 per unit manufactured |
Variable manufacturing overhead | 5 per unit manufactured |
Fixed: | |
Selling and administrative |
$20,000 per month |
Manufacturing (including depreciation of $10,000) |
30,000 per month |
Jacobs 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. Jacobs desires to maintain an ending finished goods inventory equal to 20 percent of the following month's sales and a raw materials inventory equal to 10 percent of the following month's production. January 1, 2011, inventories are in line with these policies. Actual unit sales for December and budgeted unit sales for January, February, and March of 2011 are as follows:
JACOBS INCORPORATED Sales Budget For the Months of January, February, and March 2011 |
||||
---|---|---|---|---|
Month | December | January | February | March |
Sales - Units | 5,750 | 3,000 | 10,000 | 7,000 |
Sales - Dollars | $287,500 | $150,000 | $500,000 | $350,000 |
Additional information:
NOTE: For the entire problem - do not use any negative signs with your answers unless appropriate for net income(loss) or ending balance.
(a) A production budget for January and February.
JACOBS INCORPORATED Production Budget For the Months of January and February 2011 |
|||
---|---|---|---|
January | February | March | |
Requirements for current sales | Answer | Answer | Answer |
Desired ending inventory | Answer | Answer | |
Total requirements | Answer | Answer | |
Less beginning inventory | Answer | Answer | |
Production requirements | Answer | Answer |
(b) A purchases budget in units for January.
JACOBS INCORPORATED Purchases Budget For the Month of January 2011 |
||
---|---|---|
January | February | |
Current requirements (units) | Answer | Answer |
Desired ending inventory | Answer | |
Total requirements | Answer | |
Less beginning inventory | Answer | |
Purchases (units) | Answer | |
Purchases (dollars at $10 each) | Answer |
(c) A manufacturing cost budget for January.
JACOBS INCORPORATED Manufacturing Cost Budget For the Month of January 2011 |
||
---|---|---|
Variable costs | ||
Direct materials | Answer | |
Direct labor | Answer | |
Variable manufacturing overhead | Answer | |
Total variable costs | Answer | |
Fixed manufacturing overhead | Answer | |
Total manufacturing overhead | Answer |
(d) A cash budget for January.
JACOBS INCORPORATED Cash Budget For the Month of January 2011 |
||
---|---|---|
Beginning balance | Answer | |
Receipts: | ||
December sales | Answer | |
January sales | Answer | Answer |
Total cash available | Answer | |
Disbursements: | ||
Purchases | Answer | |
Direct labor | Answer | |
Variable manufacturing overhead | Answer | |
Fixed manufacturing overhead (exclude depreciation) | Answer | |
Variable selling and administrative | Answer | |
Fixed selling and administrative | Answer | |
Dividend | Answer | Answer |
Ending Balance | Answer |
(e) A budgeted contribution income statement for January.
JACOBS INCORPORATED Budgeted Contribution Income Statement For the Month of January 2011 |
||
---|---|---|
Sales | Answer | |
Less variable costs: | ||
Cost of goods sold | Answer | |
Selling and administrative | Answer | Answer |
Contribution | Answer | |
Less fixed costs: | ||
Manufacturing overhead | Answer | |
Selling and administrative | Answer | Answer |
Net income | Answer |
(a) A production budget for January and February. | |||||
JACOBS INCORPORATED | |||||
Production Budget | |||||
For the Months of January and February 2011 | |||||
January | February | March | |||
Requirements for current sales | 3000 | 10000 | 7000 | ||
Desired ending inventory | 2000 | 1400 | 10000*20% | ||
Total requirements | 5000 | 11400 | |||
Less beginning inventory | 600 | 2000 | 3000*20% | ||
Production requirements | 4400 | 9400 | |||
JACOBS INCORPORATED | |||||
Purchases Budget | |||||
For the Month of January 2011 | |||||
January | February | ||||
Current requirements (units) | 4400 | 9400 | |||
Desired ending inventory | 940 | 9400*10% | |||
Total requirements | 5340 | ||||
Less beginning inventory | 440 | 4400*10% | |||
Purchases (units) | 4900 | ||||
Purchases (dollars at $10 each) | 49000 | ||||
(c) A manufacturing cost budget for January. | |||||
JACOBS INCORPORATED | |||||
Manufacturing Cost Budget | |||||
For the Month of January 2011 | |||||
Variable costs | |||||
Direct materials | 49000 | ||||
Direct labor | 49000 | ||||
Variable manufacturing overhead | 24500 | ||||
Total variable costs | 122500 | ||||
Fixed manufacturing overhead | 30000 | ||||
Total manufacturing overhead | 30000 | ||||
(d) A cash budget for January. | |||||
JACOBS INCORPORATED | |||||
Cash Budget | |||||
For the Month of January 2011 | |||||
Beginning balance | 7000 | ||||
Receipts: | |||||
December sales | 143750 | ||||
January sales | 75000 | 218750 | |||
Total cash available | 225750 | ||||
Disbursements: | |||||
Purchases | 49000 | ||||
Direct labor | 49000 | ||||
Variable manufacturing overhead | 24500 | ||||
Fixed manufacturing overhead (exclude depreciation) | 20000 | ||||
Variable selling and administrative | 15000 | ||||
Fixed selling and administrative | 20000 | ||||
Dividend | 6000 | 183500 | |||
Ending Balance | 42250 | ||||
(e) A budgeted contribution income statement for January. | |||||
JACOBS INCORPORATED | |||||
Budgeted Contribution Income Statement | |||||
For the Month of January 2011 | |||||
Sales | 150000 | ||||
Less variable costs: | |||||
Cost of goods sold | 65454.545 | ||||
Selling and administrative | 15000 | 80454.5455 | |||
Contribution | 69545.4545 | ||||
Less fixed costs: | |||||
Manufacturing overhead | 30000 | ||||
Selling and administrative | 20000 | 50000 | |||
Net income | 19545.4545 | ||||
Working Note: | |||||
Cost of goods sold | |||||
Opening Inventory of Materials | 4400 | 440*10 | |||
Add:Purchase of materials | 49000 | ||||
Less: Closing Inventory of Materials | 9400 | 940*10 | |||
Direct Materials Consumed | 44000 | ||||
Direct Labour | 49000 | ||||
Variable Manufacturing Overheads | 24500 | ||||
Prime Cost | 117500 | ||||
Add: Opening Inventory of Finished Goods | 15000 | 600*25 | Given | ||
Less: Closing Inventory of Finished Goods | 67045.455 | 2000*33.52 | Computed | ||
Cost of Goods Sold | 65454.545 | ||||
Working Note: Cost per unit for Value of Closing Stock | |||||
Prime Cost | 117500 | ||||
Add: Fixed Manufacturing Overheads | 30000 | ||||
Cost of Production | 147500 | ||||
Production in Units | 4400 | ||||
Cost of Production per unit (For Valuation of Closing Inventory) | 33.522727 | ||||
(147500/4400) |
Developing a Master Budget for a Manufacturing Organization Jacobs Incorporated manufactures a product with a selling...
Developing a Master Budget for a Manufacturing Organization Jacobs Incorporated manufactures a product with a selling price of $50 per unit. Units and monthly cost data follow: Variable: Selling and administrative $5 per unit sold Direct materials 10 per unit manufactured Direct labor 10 per unit manufactured Variable manufacturing overhead 5 per unit manufactured Fixed: Selling and administrative $20,000 per month Manufacturing (including depreciation of $10,000) 30,000 per month Jacobs pays all bills in the month incurred. All sales are...
Developing a Master Budget for a Manufacturing Organization Jacobs Incorporated manufactures a product with a selling price of $50 per unit. Units and monthly cost data follow: Variable: Selling and administrative $5 per unit sold Direct materials 10 per unit manufactured Direct labor 10 per unit manufactured Variable manufacturing overhead 5 per unit manufactured Fixed: Selling and administrative $20,000 per month Manufacturing (including depreciation of $10,000) 30,000 per month Jacobs pays all bills in the month incurred. All sales are...
Developing a Master Budget for a Manufacturing Organization Jacobs Incorporated manufactures a product with a selling price of $50 per unit. Units and monthly cost data follow: Variable: Selling and administrative $5 per unit sold Direct materials 10 per unit manufactured Direct labor 10 per unit manufactured Variable manufacturing overhead 5 per unit manufactured Fixed: Selling and administrative $20,000 per month Manufacturing (including depreciation of $10,000) 30,000 per month Jacobs pays all bills in the month incurred. All sales are...
Prepare a production budget for January and February 7. Developing a Master Budget Heartbreaker Inc. manufactures a product with a selling price of $60 per unit. Units and monthly cost data follow: Variable: Selling and administrative............ Direct materials.............. Direct labor.. Variable manufacturing overhead...... Fixed: Selling and administrative....... Manufacturing (including depreciation of $11,000)............ $ 5 per unit sold 12 per unit manufactured 12 per unit manufactured 6 per unit manufactured $17,000 per month 34,000 per month Heartbreaker pays all bills in...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory for each...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: 1 a. Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory...
Problem 2. Preparing Master budgets UBS Company, a manufacturing business that sells baskets, wants a master budget prepared for the first three months of this year (January, February and March). The managers of the different departments have provided the following information: The Sales Manager has projected the following sales: - January 6,000 units - February 5,000 units - March 6,000 units - Projected selling price is $40.00/unit Your Production Manager gave the following information: - Ending Inventory is to be...
Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalley Manufacturing's operations: (Click the icon to view the data.) (Click the icon to view additional data.) Read the requirements. Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Dalley Manufacturing Cash Collections Budget For the Quarter Ended March 31 Month January February March Quarter Cash sales Credits sales Total...
Petrini Corporation makes one product and it provided the following information to help prepare the master budget for the next four months of operations: a. The budgeted selling price per unit is $110. Budgeted unit sales for January, February, March, and April are 7,500, 10,600, 12,000, and 11,700 units, respectively. All sales are on credit. b. Regarding credit sales, 30% are collected in the month of the sale and 70% in the following month. c. The ending finished goods inventory...
Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to deckers manufacturing s operation Current Assets as of December 31 (prior year): Cash 4600 Accounts receivable, net 47000 Inventory 15100 Property, plant, and equipment, net 123000 Accounts payable. 43000 Capital stock. 123500 Retained earnings. 23100 a. Actual sales in December were $71,000. Selling price per unit is projected to remain stable at $12 per unit throughout the budget period. Sales...