Question

In: Accounting

Budget Preparation Westport Company is preparing its master budget for May. Use the estimates provided to...

Budget Preparation Westport Company is preparing its master budget for May. Use the estimates provided to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement.)

a. What should total sales revenue be if territories E and W estimate sales of 50,000 and 100,000 units, respectively, and the unit selling price is $35?

b. If the beginning finished goods inventory is an estimated 6,000 units and the desired ending inventory is 8,000 units, how many units should be produced?

units

c. What dollar amount of materials should be purchased at $2.50 per pound if each unit of product requires 2.5 pounds and beginning and ending materials inventories should be 12,000 and 13,500 pounds, respectively.

$

d. How much direct labor cost should be incurred if each unit produced requires 0.5 hours at an hourly rate of $16? $ e. How much manufacturing overhead should be incurred if fixed manufacturing overhead is $45,000 and variable manufacturing overhead is $2 per direct labor hour?

$

Solutions

Expert Solution

Answer a)

Calculation of total sale revenue

Total sales revenue = Aggregate number of units sold in both territories X Selling price per unit

                                     = (50,000 units + 100,000 units) X $ 35 per unit

                                    = $ 5,250,000

Therefore total sales revenue is $ 5,250,000.

Answer b)

Calculation of number of units of finished goods to be produced

Number of units of finished product to be produced = Number of units sold + desired ending inventory of finished goods – estimated beginning inventory of finished goods

                                                                                                = 150,000 units + 8,000 units – 6,000 units

                                                                                                 = 152,000 units

Therefore the company should produce 152,000 units.

Answer c)

Calculation of dollar amount of material to be purchased

Dollar amount of material to be purchased = Number of units of raw materials to be purchased X Cost per pound of raw material

                                                                                 = 381,500 pounds X $ 2.50 per pound

                                                                                  = $ 953,750

Therefore dollar amount of raw material to be purchased is $ 953,750.

Working Note:

Calculation of number of units of raw material inventory required to be purchased

Number of units of raw materials required to be purchased = Desired ending inventory of raw materials + number of units of Raw material to be used in production – beginning inventory of finished goods

                                                         = 13,500 pounds + (152,000 units X 2.5 pounds per unit) - 12,000 pounds

                                                        = 381,500 pounds

Answer d)

Calculation of direct labor cost to be incurred

Direct labor cost to be incurred = Number of units to be produced X labor hours required per unit X Labor rate per direct labor hour

                                                                = 152,000 units X 0.5 hours per unit X $ 16 per labor hour

                                                                = $ 1,216,000

Therefore direct labor cost to be incurred is $ 1,216,000.

Calculation of total manufacturing overhead cost to be incurred

Total manufacturing overhead cost to be incurred = Estimated Fixed manufacturing overhead cost + Estimated variable manufacturing cost

                                                                                            = $ 45,000 + $ 152,000

                                                                                             = $ 197,000                              

Working Note:

Calculation of variable manufacturing overhead cost to be incurred

Variable manufacturing overhead cost to be incurred = Number of units to be produced X labor hours required per unit X variable manufacturing overhead rate per direct labor hour

                                                                = 152,000 units X 0.5 hours per unit X $ 2 per labor hour

                                                                = $ 152,000

Therefore Variable manufacturing overhead cost to be incurred is $ 152,000.


Related Solutions

Budget Preparation Westport Company is preparing its master budget for May. Use the estimates provided to...
Budget Preparation Westport Company is preparing its master budget for May. Use the estimates provided to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement.) a. What should total sales revenue be if territories E and W estimate sales of 50,000 and 100,000 units, respectively, and the unit selling price is $27? b. If the beginning finished goods inventory is an estimated 7,000 units and the desired ending in- ventory...
Westport Company is preparing its master budget for May. Use the estimates provided to determine the...
Westport Company is preparing its master budget for May. Use the estimates provided to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement.) a. What should total sales revenue be if territories E and W estimate sales of 50,000 and 100,000 units, respectively, and the unit selling price is $65? $Answer b. If the beginning finished goods inventory is an estimated 6,000 units and the desired ending inventory is 11,000...
Budget Preparation Collins Company is preparing its master budget for April. Use the given estimates to...
Budget Preparation Collins Company is preparing its master budget for April. Use the given estimates to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement.) a. What should total sales revenue be if territories A and B estimate sales of 10,000 and 12,000 units, respectively, and the unit selling price is $40? $Answer b. If the beginning finished goods inventory is an estimated 2,000 units and the desired ending inventory...
Renfro Company is preparing its master budget for May. Renfro’s sales budget shows expected sales for...
Renfro Company is preparing its master budget for May. Renfro’s sales budget shows expected sales for May of 100,000 units. The beginning finished goods inventory is an estimated 12,000 units and the desired ending inventory is 9,000 units. Materials are expected to be purchased at $2 per pound and each unit of product requires 3 pounds of material. Beginning and ending materials inventories are expected to be 24,000 and 20,000 pounds, respectively. Direct labor for each unit produced requires 0.5...
Master Budget Project Okay Company is preparing to build its master budget. The budget will detail...
Master Budget Project Okay Company is preparing to build its master budget. The budget will detail each quarter’s activity and the activity for the year in total. The master budget will be based on the following information: a. This will be the first year of operation for Okay Company. b. Budgeted unit sales by quarter for 2017 are projected as follows: First quarter 6,300, Second quarter 6,100, Third quarter 6,100 & Fourth quarter 6,450. First and second quarter 2018 budgeted...
Master Budget Project Okay Company is preparing to build its master budget. The budget will detail...
Master Budget Project Okay Company is preparing to build its master budget. The budget will detail each quarter’s activity and the activity for the year in total. The master budget will be based on the following information: This will be the first year of operation for Okay Company. Budgeted unit sales by quarter for 2017 are projected as follows: First quarter 6,300, Second quarter 6,100, Third quarter 6,100 & Fourth quarter 6,450. First and second quarter 2018 budgeted sales units...
1A . Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its...
1A . 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,000,000 units. Quarterly sales are 20%, 25%,25%,and 30% respectively.The sales price is expected to be $40 per unit for the first three quartersand $45 per unit beginning in the fourth quarter.Sales in the first quarter of 2018 are expected to be 20% higher than the budgeted sales...
Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single...
Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single product at a price of $25 per unit. Sales (in units) are forecasted at 41,000 for January, 61,000 for February, and 51,000 for March. Cost of goods sold is $12 per unit. Other expense information for the first quarter follows. Commissions 9 % of sales dollars Rent $ 18,000 per month Advertising 13 % of sales dollars Office salaries $ 72,000 per month Depreciation...
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash...
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash collections from sales for the first quarter of 2019. They expect sales in January to be $400,000, February to be $300,000, and March to be $500,000. !0% of the sales will be paid for in cash. The remainder will be charged on account. From past experience, the company knows their customers take 3 months to pay their bills in total, with 40% of a...
Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production,...
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,000,000 units. Quarterly sales are 18%, 23%, 23%, and 36%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $43 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT