Question

In: Accounting

Diane Buswell is preparing the 2019 budget for one of Current Designs' kayaks. Extensive meetings with...

Diane Buswell is preparing the 2019 budget for one of Current Designs' kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2019.

Quarter 1

1,000 kayaks

Quarter 2

1,500 kayaks

Quarter 3

750 kayaks

Quarter 4

750 kayaks

Current Designs' policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarter's anticipated sales. Preliminary sales projections for 2020 are 1,100 units for the first quarter and 1,500 units for the second quarter. Ending inventory of finished goods at December 31, 2018, will be 200 kayaks.

Production of each kayak requires 54 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). Company policy is that the ending inventory of polyethylene powder should be 25% of the amount needed for production in the next quarter. Assume that the ending inventory of polyethylene powder on December 31, 2018, is 19,400 pounds. The finishing kits can be assembled as they are needed. As a result, Current Designs does not maintain a significant inventory of the finishing kits.

The polyethylene powder used in these kayaks costs $1.50 per pound, and the finishing kits cost $170 each. Production of a single kayak requires 2 hours of time by more experienced, type I employees and 3 hours of finishing time by type II employees. The type I employees are paid $15 per hour, and the type II employees are paid $12 per hour.

Selling and administrative expenses for this line are expected to be $45 per unit sold plus $7,500 per quarter. Manufacturing overhead is assigned at 150% of labor costs.

Instructions:

Determine a sales price for your kayaks that you feel is reasonable and a short explanation on this decision, then using the sales projections and other budgets, prepare the following:

a. Sales Budget

b. Budgeted Income Statement

Solutions

Expert Solution

Production Budget

For the year ended 2019

Particulars Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total   
Expected Unit Sales 1000 1500 750 750 4000
Add: desired ending finished goods units 300 150 150 220 820
Total required units 1300 1650 900 970 4820
Less: beginning finished goods units -200 -300 -150 -150 -800
Required production units 1100 1350 750 820 4020

DIrect Materials Budget

For the year ended 2019

Particulars Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total   
Units to be produced 1100 1350 750 820 4020
Pounds of Polyethylene powder per unit 54 54 54 54 54
Total Pounds needed for production 59400 72900 40500 44280 217080
Add: desired ending inventory of powder 18225 10125 11070 15930 55350
Total pounds of powder required 77625 83025 51570 60210 272430
Less: beginning inventory of powder -19400 -18225 -10125 -11070 -58820
Pounds of Polyethylene powder to be purchased 58225 64800 41445 49140 213610
Cost per pound 1.5 1.5 1.5 1.5 1.5
Cost of Polyethylene powder to be purchased 87337.5 97200 62167.5 73710 320415
Cost of required finishing kits 165000 202500 112500 123000 603000
Total Cost of Direct Materials 252337.5 299700 174667.5 196710 923415

*Production finished goods units for Quarter 1, 2018 = 1100 + (20%*1500) - 220 = 1180 units

Raw Material Required = 1180*54 = 63720 pounds

Closing stock for Qtr 4, 2017 = 25% of 63720 = 15930 pounds

Direct Labor Budget

For the year ended 2019

Particulars Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total   
Units to be produced 1100 1350 750 820 4020
No. of hours of more skilled labor/ unit 2 2 2 2 2
Total no. of more skilled labor 2200 2700 1500 1640 8040
Hourly rate for more skilled labor 15 15 15 15 15
Total Cost of more skilled labor 33000 40500 22500 24600 120600
Units to be produced 1100 1350 750 820 4020
No. of hours of less skilled labor/ unit 3 3 3 3 3
Total no. of less skilled labor 3300 4050 2250 2460 12060
Hourly rate for less skilled labor 12 12 12 12 12
Total Cost of less skilled labor 39600 48600 27000 29520 144720
Total Cost for Direct Labor 72600 89100 49500 54120 265320

Manufacturing Overhead Budget

For the year ended 2019

Particulars Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total   
Total Cost for Direct Labor 72600 89100 49500 54120 265320
Manufacturing overhead rate per direct labor dollar 150% 150% 150% 150% 150%
Manufacturing overhead cost 108900 133650 74250 81180 397980

Selling and administrative budget

For the year ended 2019

Particulars Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total   
Expected Sales Units 1000 1500 750 750 4000
Variable selling and administrative costs @ $45 per unit 45000 67500 33750 33750 180000
Fixed selling and administrative cost 7500 7500 7500 7500 30000
Total Selling and administrative cost 52500 75000 41250 41250 210,000

Feel free to ask any clarification through comment section and aslo you can give feedback / rating by doing like the answer.

Thank You


Related Solutions

CURRENT DESIGNS Diane Buswell is preparing the 2019 budget for one of Current Designs' kayaks. Extensive...
CURRENT DESIGNS Diane Buswell is preparing the 2019 budget for one of Current Designs' kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2019. Quarter 1 1,000 kayaks Quarter 2 1,500 kayaks Quarter 3 750 kayaks Quarter 4 750 kayaks Current Designs' policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarter's anticipated sales. Preliminary sales projections for 2020 are...
Diane Buswel! is preparing the 201/ budget for one of Current Designs rotomolded kayaks Extensive meetings...
Diane Buswel! is preparing the 201/ budget for one of Current Designs rotomolded kayaks Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2017. Quarte 1,000 kayaks Quarter 2 1,500 kayaks Quarter 3 750 kayaks Quarter 4 750 kayaks Current Designs policy is to have finished goods ending inventory in a quarter equal to 20% of the next quarters anticipated sales. Preliminary sales projections for 2018 are 1,100 units...
Current Designs manufactures two different types of kayaks, rotomolded kayaks and composite kayaks. The following information...
Current Designs manufactures two different types of kayaks, rotomolded kayaks and composite kayaks. The following information is available for each product line. Rotomolded Composite Sales price/unit $800 $2,000 Variable costs/unit $480 $1,340 The company’s fixed costs are $706,160. An analysis of the sales mix identifies that rotomolded kayaks make up 80% of the total units sold. Correct answer iconYour answer is correct. Determine the weighted-average unit contribution margin for Current Designs. Weighted-average unit contribution margin $ eTextbook and Media   ...
Current Designs manufactures two different types of kayaks, rotomoulded kayaks and composite kayaks. The following information...
Current Designs manufactures two different types of kayaks, rotomoulded kayaks and composite kayaks. The following information is available for each product line. Rotomoulded Composite Sales price/unit $1,120 $2,360 Variable costs/unit $670 $1,580 The company’s fixed costs are $968,000. An analysis of the sales mix identifies that rotomoulded kayaks make up 80% of the total units sold. Determine the weighted-average unit contribution margin for Current Designs. Weighted-average unit contribution margin $ Determine the break-even point in units for Current Designs and...
Current Designs Problem 5 Bill Johnson, sales manager, and Diane Buswell, controller, at Current Designs are...
Current Designs Problem 5 Bill Johnson, sales manager, and Diane Buswell, controller, at Current Designs are beginning to analyze the cost considerations for one of the composite models of the kayak division. They have provided the following production and operational costs necessary to produce one composite kayak. Kevlar® $230 per kayak Resin and supplies $190 per kayak Finishing kit (seat, rudder, ropes, etc.) $160 per kayak Labor $450 per kayak Selling and administrative expenses—variable $400 per kayak Selling and administrative...
As you learned in the previous chapters, Current Designs has two main product lines—composite kayaks, which...
As you learned in the previous chapters, Current Designs has two main product lines—composite kayaks, which are handmade and very labor-intensive, and rotomolded kayaks, which require less labor but employ more expensive equipment. Current Designs’ controller, Diane Buswell, is now evaluating several different methods of assigning overhead to these products. It is important to ensure that costs are appropriately assigned to the company’s products. At the same time, the system that is used must not be so complex that its...
Petesy Corporation is preparing its Master Budget for 2019. Budget information is as follows:                           &nb
Petesy Corporation is preparing its Master Budget for 2019. Budget information is as follows:                                                         Sales                      Production Cost                                Operating Expenses 2019               1st Quarter          P280,000              P192,000                              P64,000                         2nd Quarter         320,000               200,000                                  68,000                         3rd Quarter          360,000               224,000                                  72,000                         4th Quarter          352,000               200,000                                  76,000 2020               1st Quarter          320,000               224,000                                  72,000 The budgeted Finished Goods Inventories are:         2018       March 31             P56,000                         June 30                 52,000                         September 30      60,000                         December 31     48,000 The company uses...
HammerTime is preparing their 2019 budget. They want to look at static budgets and flexible budgets...
HammerTime is preparing their 2019 budget. They want to look at static budgets and flexible budgets to determine which is best for them. They estimate sales/production will be between 2,000,000 and 4,000,000 boxes of nails per month. They want to be able to understand their budget variances as well. Question 1: Prepare some budgets in Excel for HammerTime. a) Show the static budget based on 3,000,000 units (boxes) produced. b) Show the flexible budget based on 2,000,000 units (boxes) produced....
A Landscaping Inc. is preparing its budget for the first months of 2019. The next step...
A Landscaping Inc. is preparing its budget for the first months of 2019. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. 10% of all sales are for Cash. Credit customers usually pay 20% of their fee in the month that service is provided, 60% the month after, 18% the second month after receiving service. The remaining 2% is written off...
How can you analyze the current budget of a company by preparing an analysis of the...
How can you analyze the current budget of a company by preparing an analysis of the financial results with specific emphasis on positive and negative variances and propose possible managerial actions to correct these variances?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT