Question

Prepare the following budgets: 1. Beginning balance sheet 2. Sales budget 3. Production budget in units...

Prepare the following budgets:
1. Beginning balance sheet
2. Sales budget
3. Production budget in units
4. Materials acquisition budget
5. Direct labor budget

Camarillo Manufacturing Company was established to manufacture two types of pipe fittings, XL1 and XL2. The manufacturing process involves molding the fittings and then smoothing them. The firm was initially capitalized with $500,000 as an S Corporation. The firm purchased equipment for $450,000 with cash of $125,000 and a note payable of $325,000. It also acquired furniture for $120,000 with cash of $60,000 and a note payable of $60,000. Management is now preparing the master budget for the first year of operations.

Sales Budget: Management expects to meet established market prices for its pipe fittings of $40 for XL1 and $32 for XL2. Sales representatives have estimated that total sales of XL1 fittings will be 4,500 units and sales of XL2 will be 12,000 units. Production Budget: Management has expressed a desire to have 1,000 units of XL1 and 3,000 units of XL2 in ending inventory. Material Acquisition Budget:The firm’s industrial engineer has prepared standards that call for 0.6 pounds of material per XL1 casting and 0.4 pounds per XL2 casting. Both products require the same material. Management also desires to end the period with 2,000 pounds of material in raw materials inventory. The purchasing agent anticipates that the metal can be purchased at an average cost of $4 per pound. Direct Labor Budget:The standards for a unit of XL1 call for 0.5 hours of direct labor in Molding and 0.3 hours in Smoothing. The standards for a unit of XL2 call for 0.4 hours in Molding and 0.2 hours in Smoothing. Management’s anticipated average cost for labor is $15 per hour.

Homework Answers

Answer #1

1. Beginning balance sheet

Assets
Cash 315000
Equipment 450000
Furniture 120000
Total assets 885000
Liabilities and Stockholders' Equity
Notes payable 385000
Stockholders' equity 500000
Total liabilities and stockholders' equity 885000

2.

Sales Budget
XL1 XL2
Budgeted sales units 4500 12000
Sales price per unit $ $          40 $          32
Budgeted sales $ 180000 384000

3.

Production Budget
XL1 XL2
Budgeted sales units 4500 12000
Add desired ending inventory 1000 3000
Budgeted production in units 5500 15000

4.

Materials Acquisition Budget
XL1 XL2 Total
Budgeted production in units 5500 15000
Raw Material required per unit (pounds) 0.6 0.4
Raw Material required for production (pounds) 3300 6000 9300
Add desired ending inventory of raw materials 2000
Total needs 11300
Material price per pound $ $             4
Budgeted materials purchases $ 45200

5.

Direct Labor Budget
XL1 XL2 Total
Budgeted production in units 5500 15000
Direct labor hours required per unit:
Molding 0.5 0.4
Smoothing 0.3 0.2
Total direct labor hours required per unit 0.8 0.6
Total direct labor hours required 4400 9000 13400
Direct labor rate per hour $ 15 15 15
Budgeted direct labor cost $ 66000 135000 201000
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
AGENDA: PROFIT PLANNING (BUDGETING) Building a master budget. 1. Sales budget 2. Production budget 3. Direct...
AGENDA: PROFIT PLANNING (BUDGETING) Building a master budget. 1. Sales budget 2. Production budget 3. Direct materials budget 4. Direct labor budget 5. Manufacturing overhead budget 6. Ending finished goods inventory budget 7. Selling and administrative expenses budget 8. Cash budget 9. Budgeted income statement 10. Budgeted balance sheet OVERVIEW OF BUDGETING A budget is a detailed plan for acquiring and using financial and other resources over a specified period. Budgeting involves two stages: • Planning: Developing objectives and preparing...
Prepare the sales budget, production budget, direct materials budget, direct labor budget, manufacturing overhead budget, SGA...
Prepare the sales budget, production budget, direct materials budget, direct labor budget, manufacturing overhead budget, SGA budget, and budgeted income statement for ABC Company for the year, given the following information: ABC expects to sell 10,000 units for the year at $175 per unit. ABC Company begins the year with 2,000 units and desires ending inventory of 7,000 units. To produce 1 unit, it takes the following: DIRECT MATERIALS: To produce 1 unit: 10 pounds Waste per unit: 1 pound...
Blossom, Inc. prepared the following master budget items for July:       Production and sales 28,000 units...
Blossom, Inc. prepared the following master budget items for July:       Production and sales 28,000 units   Variable manufacturing costs:      Direct materials $ 28,000      Direct labor $ 61,000      Variable manufacturing overhead $ 42,000   Fixed manufacturing costs $ 130,000   Total manufacturing costs $ 261,600     During July, Blossom actually sold 34,000 units. Prepare a flexible budget for Blossom based on actual sales. (Do not round your intermediate calculations.) Production and Sales UNITS Variable manufacturing costs Direct materials Direct labor Variable manufacturing overhead...
REQUIREMENTS:   1)    Sales Budget   2)    Production Budget Budgets should be for the individual three (3) months of the...
REQUIREMENTS:   1)    Sales Budget   2)    Production Budget Budgets should be for the individual three (3) months of the first quarter of 2019. Include a quarterly total column on the right side. Each budget/requirement should be in a separate tab within one spreadsheet. All pages should be in portrait format using the same font. Use proper rounding and show two (2) decimal places of accuracy on dollar amounts. Round up and show whole amounts on all other figures. (Hint) Excel provides functions for...
2) Still Company manufactures one product. Its variable manufacturing overhead is applied to production based on...
2) Still Company manufactures one product. Its variable manufacturing overhead is applied to production based on direct labor-hours and its standard cost card per unit is as follows: Direct materials: 10 pounds at $8.00 per pound............................     $80.00 Direct labor: 4 hours at $14 per hour.........................................           56.00 Variable overhead: 4 hours at $5 per hour..................................         20.00 Total standard cost per unit......................................................          $156.00 The planning budget for April was based on producing and selling 50,000 units. However, during...
Ramos Co. provides the following sales forecast and production budget for the next four months. April...
Ramos Co. provides the following sales forecast and production budget for the next four months. April May June July Sales (units) 530 610 560 630 Budgeted production (units) 470 600 570 570 The company plans for finished goods inventory of 150 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 30% of next month’s production needs. Beginning direct...
Ramos Co. provides the following sales forecast and production budget for the next four months: April...
Ramos Co. provides the following sales forecast and production budget for the next four months: April May June July Sales (units) 670 750 700 770 Budgeted production (units) 610 740 710 710 The company plans for finished goods inventory of 290 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 20% of next month’s production needs. Beginning direct...
Fultz Company has accumulated the following budget data for the year 2020. 1. Sales:  31,270 units, unit...
Fultz Company has accumulated the following budget data for the year 2020. 1. Sales:  31,270 units, unit selling price $ 88. 2. Cost of one unit of finished goods: direct materials  1 pound at $ 5 per pound, direct labor  3 hours at $ 13 per hour, and manufacturing overhead $6 per direct labor hour. 3. Inventories (raw materials only): beginning,  10,110 pounds; ending,  15,430 pounds. 4. Selling and administrative expenses: $ 170,000; interest expense: $ 30,000. 5. Income taxes: 30% of income before income...
1) Pardoe Inc., manufactures a single product in which variable manufacturing overhead is assigned on the...
1) Pardoe Inc., manufactures a single product in which variable manufacturing overhead is assigned on the basis of standard direct labor-hours. The company uses a standard cost system and has established the following standards for one unit of product: Standard Quantity Standard Price or Rate Standard Cost Direct materials 1.5 pounds $3.00 per pound $4.50 Direct labor 0.6 hours $6.00 per hour $3.60 Variable manufacturing overhead 0.6 hours $1.25 per hour $0.75 During March, the following activity was recorded by...
P13-1 Prepare budgeted income statement and supporting budgets. Cook Farm Supply Company manufactures and sells a...
P13-1 Prepare budgeted income statement and supporting budgets. Cook Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available for preparing budgets for Snare for the first 2 quarters of 2017. 1. Sales: quarter 1, 40,000 bags; quarter 2, 56,000 bags. Selling price is $60 per bag. 2. Direct materials: each bag of Snare requires 4 pounds of Gumm at a cost of $3.80 per      pound and 6 pounds of Tarr at $1.50 per...