Quarter 1 | 1,200 kayaks |
Quarter 2 | 1,500 kayaks |
Quarter 3 | 750 kayaks |
Quarter 4 | 700 kayaks |
KK’s 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 2022 are 1,100 units for the first quarter and 1,500 units for the second quarter. Ending inventory of finished goods at December 31, 2020, 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, 2020, is 19,400 pounds. The finishing kits can be assembled as they are needed. As a result, KK does not maintain a significant inventory of the finishing kits.
The polyethylene powder used in these kayaks costs $1.55 per pound, and the finishing kits cost $150 each. Production of a single kayak requires 3 hours of time by more experienced, type I employees and 4 hours of finishing time by type II employees. The type I employees are paid $20 per hour, and the type II employees are paid $15 per hour.
Selling and administrative expenses for this line are expected to be $50 per unit sold plus $7,300 per quarter. Manufacturing overhead is assigned at 150% of labor costs.
Instructions:
Prepare the required budgets using one excel file or google drive (sheets), you MAY use multiple tabs in a file (highly encouraged!).
All calculations should be done using formulas in your spreadsheet, numbers that transfer from one location to another should be linked/referenced.
Prepare the following budgets (include quarterly and yearly totals) in excel or google drive:
production budget
direct materials budget
direct labor budget
manufacturing overhead budget
selling and administrative budget
Assume you are management and it is up to YOU to determine a sales price for your kayak that reasonable and provide your reasoning for this sales price decision.
Using your sales pricing decision, prepare the following budgets (include quarterly and yearly totals):
10. Sales Budget
11. Budgeted Income Statement
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Kawaii Kayaks (KK) Richard Fiesel is preparing the 2021 budget for one of KK’s kayaks. Extensive meetings with members of the sales department and executive management team have resulted in the following unit sales projections for 2021.
Quarter 1 Quarter 2 Quarter 3 Quarter 41,000 kayaks 1,500 kayaks 750 kayaks 750 kayaksCurrent 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 2014 are 1,100 units for the first quarter and 1,500 units for the second quarter. Ending inventory of finished goods at December 31, 2012, will be 200 rotomolded kayaks.Production of each kayak requires 54 pounds of polyethylene powder and a...
Quarter 1 Quarter 2 Quarter 3 Quarter 4 1,000 kayaks 1,500 kayaks 750 kayaks 750 kayaksCurrent 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 2021 are 1,100 units for the first quarter and 1,500 units for the second quarter. Ending inventory of finished goods at December 31, 2019, will be 200 rotomolded kayaks.Production of each kayak requires 54 pounds of polyethylene powder and...
ašes Current Designs Excel CD9 Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded kayaks. Extensive meetings with members of the sales department and executive team have resulted in the fol- lowing unit sales projections for 2020 1,000 kayaks 1,500 kayaks 750 kayaks 750 kayaks Quarter Quarter 2 Quarter 3 Quarter 4 Current Designs' policy is to have finished goods ending inventory in a quarter equal to 20 % of the next quarter's anticipated sales. Preliminary...
Current Designs CD9 Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded Extensive meetings with members of the sales department and executive team have resulted in the lowing unit sales projections for 2020. 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 2021...
Current Designs CD9 Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded Extensive meetings with members of the sales department and executive team have resulted in the lowing unit sales projections for 2020. 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 2021...
Diane Buswell is preparing the 2020 budget for one of Current Designs' rotomolded kayaks. Extensive meetings with members of the sales department and executive team have Quarter 1 Quarter 2 Quarter 3 Quarter 4 1,900 kayaks 2,600 kayaks 1,550 kayaks 1,550 kayaks Current Designs' polRY to have finished goods ending inventory in a quarter equal to 15% of the next quarter's anticipated sales, preliminary sales project ons for 2021 are 1,100 units for the first quarter and 2,600 units for...
Decision Making 12-1 The executive team at Current Designs has gathered to evaluate the company’s operations for the last month. One of the topics on the agenda is a special order to produce a batch of 20 kayaks for a client. Mike Cichanowski asked the others if the special order caused any particular problems in the production process. Dave Thill, the production manager, made the following comments: “Since we wanted to complete this order quickly and make a good first...
E10.18 Prepare quarterly sales budgets. Roche and Young, CPAS, are preparing their service revenue (sales) budget for 2020. Their practice is divided into three departments: auditing, tax, and consulting. Billable hours for each department, by quarter, are as follows: Department Quarter 1 Quarter 2 Quarter 3 Quarter 4 Auditing 2,200 1,600 2,000 2,400 3,000 2,500 Тах 2,400 2,000 Consulting 1,500 1,500 1,500 1,500 Average hourly billing rates are $60 for auditing, $70 for tax, and $80 for consulting services. Instructions...
SarasotaCompany 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,200,000 units. Quarterly sales are 18%, 25%, 23%, and 34%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $47 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher than...
Pargo Company is preparing its master budget for 2020. 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 18%, 23%, 24%, and 35%, respectively. The sales price is expected to be $41 per unit for the first three quarters and $43 per unit beginning in the fourth quarter. Sales in the first quarter of 2021 are expected to be 15% higher...