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:
(c) A manufacturing cost budget for January.
JACOBS INCORPORATED Manufacturing Cost Budget For the Month of January 2011 |
||
---|---|---|
Variable costs | ||
Direct materials | ? | |
Direct labor | ? | |
Variable manufacturing overhead | ? | |
Total variable costs | ? | |
Fixed manufacturing overhead | ? | |
Total manufacturing overhead | ? |
(d) A cash budget for January.
JACOBS INCORPORATED Cash Budget For the Month of January 2011 |
||
---|---|---|
Beginning balance | ? | |
Receipts: | ||
December sales | ? | |
January sales | ? | ? |
Total cash available | ? | |
Disbursements: | ||
Purchases | ? | |
Direct labor | ? | |
Variable manufacturing overhead | ? | |
Fixed manufacturing overhead (exclude depreciation) | ? | |
Variable selling and administrative | ? | |
Fixed selling and administrative | ? | |
Dividend | ? | ? |
Ending Balance | ? |
(e) A budgeted contribution income statement for January.
JACOBS INCORPORATED Budgeted Contribution Income Statement For the Month of January 2011 |
||
---|---|---|
Sales | ? | |
Less variable costs: | ||
Cost of goods sold | ? | |
Selling and administrative | ? | ? |
Contribution | ? | |
Less fixed costs: | ||
Manufacturing overhead | ? | |
Selling and administrative | ? | ? |
Net income | ? |
Production Budget | ||
Jan | Feb | |
Budgeted Sales in Units | 3,000 | 10,000 |
Add: Desired Ending Inventory | 2,000 | 1,400 |
Total Finished Goods Inventory Needed | 5,000 | 11,400 |
Less: Beginning Inventory | 600 | 2,000 |
Budgeted Production in Units | 4,400 | 9,400 |
c.
Jacobs
Inc. Maufacturing Cost Budget For the month of January 2011 |
|
Variable Costs | |
Direct Materials | $ 44,000 |
Direct Labor | 44,000 |
Variable Manufacturing Overhead | 22,000 |
Total Variable Costs | $ 110,000 |
Fixed Manufacturing Overhead | 30,000 |
Total Manufacturing Costs | $ 140,000 |
d.
Jacobs
Inc. Cash Budget For the month of January 2011 |
||
Beginning balance | $ 7,000 | |
Receipts | ||
December Sales | 143,750 | |
January Sales | 75,000 | 218,750 |
Total cash available | $ 225,750 | |
Disbursements | ||
Purchases | 49,000 | |
Direct labor | 44,000 | |
Variable manufacturing overhead | 22,000 | |
Fixed manufacturing overhead | 20,000 | |
Variable selling and administrative overhead | 15,000 | |
Fixed selling and administrative overhead | 20,000 | |
Dividends | 6,000 | 176,000 |
Ending balance | $ 49,750 |
e.
Jacobs
Inc. Budgeted Contribution Margin Income Statement For the month of January 2011 |
||
Sales Revenue | $ 150,000 | |
Variable Costs | ||
Variable Cost of Goods Sold | 75,000 | |
Variable Selling and Administrative | 15,000 | 90,000 |
Contribution Margin | 60,000 | |
Fixed Costs | ||
Manufacturing | 30,000 | |
Selling and Administrative | 20,000 | 50,000 |
Net Income | $ 10,000 |
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...
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...
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...
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...
Petrini Corporation makes one product and it provided the following information to help prepare the master budget for the next four months of operations: 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. Regarding credit sales, 30% are collected in the month of the sale and 70% in the following month. The ending finished goods inventory equals 30% of...