Question

In: Accounting

creating a master budget purchase prices are forecast for direct materials: Tea Lemonade Syrup $1200 per...

creating a master budget

purchase prices are forecast for direct materials:

Tea Lemonade
Syrup $1200 per lot $1100 per lot
Containers $1000 per lot $1000 per lot
Packaging $800 per lot $800 per lot



Summary data used in developing budgets for 2017 are as follows:
Sales:
a. Tea, 1080 lots at $9,000 selling price per lot.
b. lemonade, 540 lots at $8,500 selling price per lot.

Opening stock of direct materials:

a. Syrup for tea, 80 lots at $1,100 purchase price per lot.
b. Syrup for lemonade, 70 lots at $1,000 purchase price per lot.
c. Containers, 200 lots at $950 purchase price per lot.
d. Packaging, 400 lots at $900 purchase price per lot.
Opening (1 January 2017) stock of finished goods:
a. Tea, 100 lots at $5,300 per lot.
b. lemonade, 50 lots at $5,200 per lot.
Target closing (31 December 2017) stock of direct materials:
a. Syrup for tea, 30 lots.
b. Syrup for lemonade, 20 lots.
c. Containers, 100 lots.
d. Packaging, 200 lots.
Target closing (31 December 2017) stock of finished goods:
a. tea, 20 lots.
b. lemonade, 10 lots.
Each lot requires 20 direct manufacturing labor hours at the 2017 budgeted rate of $25
per hour. Indirect manufacturing labor costs are included in the manufacturing
overhead forecast.
Variable manufacturing overhead is forecast to be $600 per hour of bottling time;
bottling time is the time the filling equipment is in operation. It takes 2 hours to bottle
one lot of tea and 2 hours to bottle one lot of lemonade. Fixed
manufacturing overhead is forecast to be $1,200,000 for 2017.
Hours of budgeted bottling time is the sole allocation base for all fixed manufacturing
overhead.
Administration costs are forecast to be 10% of the cost of goods manufactured for 2017.
Marketing costs are forecast to be 12% of sales for 2017. Distribution costs are forecast
to be 8% of sales for 2017.
Required:
Using the first-in, first-out (FIFO) method for costing all stock. Prepare the following budgets for 2017:
1. Revenue Budget (in $)
2. Production Budget (in units)
3. Direct materials usage budget (in units and $)
4. Direct materials purchases budget (in units and $)
5. Direct manufacturing labor budget
6. Manufacturing overhead costs budget
7. Closing finished goods stock budget
8. Cost of goods sold budget
9. Marketing costs budget
10. Distribution costs budget
11. Administration costs budget
12. Budgeted Profit and loss account (Income
Statement)

Solutions

Expert Solution


Related Solutions

Delaware Corp. prepared a master budget that included $16,360 for direct materials, $28,100 for direct labor,...
Delaware Corp. prepared a master budget that included $16,360 for direct materials, $28,100 for direct labor, $15,900 for variable overhead, and $38,900 for fixed overhead. Delaware Corp. planned to sell 4,090 units during the period, but actually sold 4,300 units. What would Delaware’s direct materials cost be if it used a flexible budget for the period based on actual sales? (Do not round your intermediate calculations.) Delaware Corp. prepared a master budget that included $16,200 for direct materials, $52,650 for...
Explain the components and order for creating a Master Budget.
Explain the components and order for creating a Master Budget.
Why is the sales forecast so important in developing the master budget?
Why is the sales forecast so important in developing the master budget?
What is a master budget and how the sales forecast use as the starting point in...
What is a master budget and how the sales forecast use as the starting point in budgeting?
Direct materials are added uniformly throughout a process. Direct materials cost, BWIP $25,000 Direct materials per...
Direct materials are added uniformly throughout a process. Direct materials cost, BWIP $25,000 Direct materials per equivalent unit $3.97 Completed and transferred out units 25,950 7,500 units were 35% complete with respect to direct materials in ending WIP. Using the weighted average method, which of the following is TRUE ? Answers: a. Direct materials cost attributed to units completed and transferred out: $128,021.50 Direct materials cost attributed to units in ending inventory: $29,775.00 b. Direct materials cost attributed to units...
Prepare GradyGrady​'s direct materials​ budget, direct labor​ budget, and manufacturing overhead budget for the year. Round...
Prepare GradyGrady​'s direct materials​ budget, direct labor​ budget, and manufacturing overhead budget for the year. Round the direct labor hours needed for​ production, budgeted overhead​ costs, and predetermined overhead allocation rate to two decimal places. Round other amounts to the nearest whole number. Grady​, Inc. manufactures model airplane kits and projects production at 650​, 500​, 450​, and 600 kits for the next four quarters. First Quarter                                                            Second   Quarter        Third Quarter               Fourth Quarter                   Total Direct materials (ounces) per kit Direct...
-budgeted income statement – direct materials budget – production budget – sales budget -sales budget –...
-budgeted income statement – direct materials budget – production budget – sales budget -sales budget – production budget – direct materials budget – budgeted income statement Who would typically be responsible for the direct material quantity variance? -the production manager -the chief financial officer -the purchasing manager -the human resources manager Which of the following is not a component of the operating budget? -sales budget -selling and administrative budget -Budgeted balance sheet -raw materials purchases budget Top-down budgeting is: -when...
Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows.
  Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows.Sales. Sales for the year are expected to total 1,700,000 units. Quarterly sales are 19%, 27%, 23%, and 31%, respectively. The sales price is expected to be $42 per unit for the first three quarters and $44 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 15% higher...
Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows.
Do It! Review 21-2 Your answer is partially correct. Try again. Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 2,000,000 units. Quarterly sales are 22%, 26%, 27%, and 25%, respectively. The sales price is expected to be $40 per unit for the first three quarters and $47 per unit beginning in the fourth quarter. Sales in...
Direct Materials Purchases Budget: Direct Labor Budget Crescent Company produces stuffed toy animals; one of these...
Direct Materials Purchases Budget: Direct Labor Budget Crescent Company produces stuffed toy animals; one of these is “Arabeau the Cow.” Each Arabeau takes 0.20 yard of fabric (white with irregular black splotches) and 10 ounces of polyfiberfill. Fabric costs $3.40 per yard and polyfiberfill is $0.05 per ounce. Crescent has budgeted production of Arabeaus for the next four months as follows: Units October 44,000 November 80,000 December 60,000 January 40,000 Inventory policy requires that sufficient fabric be in ending monthly...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT