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

First - prepare the following:

  1. production budget
  2. direct materials budget
  3. direct labor budget
  4. manufacturing overhead budget
  5. selling and administrative budget for this product line by quarter and in total for 2019.

Second – Determine a selling price that is reasonable for these kayaks, then based upon the sales projections, prepare the following:

  1. Sales Budget
  2. Budgeted Income Statement

* note: i need it step by step please

Solutions

Expert Solution

Please find the solution, if you have any questions, Please let me know in the comments section, Will be happy to help you. Thanks.

ekkarill92 answered 1 month ago
Next > < Previous

Related Solutions

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...
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...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT