Question
Below is pretty much the assignment description. Attached is the template which also describes the assignment. Also attached is the solution worksheet. I do not
Below is pretty much the assignment description. Attached is the template which also describes the assignment. Also attached is the solution worksheet. I do not need the whole thing answered. Just the highlighted part that includes my name, Ajia. Please read everything before answering.
Project-Analysis, Sales Promotions
Hillside Furniture Company makes outdoor furniture from recycled products, including plastics and wood by-products. Its three furniture products are gliders, chairs with footstools, and tables. The products appeal primarily to cost-conscious consumers and those who value the recycling of materials. The company wholesales its products to retailers and various mass merchandisers. Because of the seasonal nature of the products, most orders are manufactured during the winter months for delivery in the early spring. Michael Cain, founder and owner, is dismayed that sales for two of the products are tracking below budget. The following chart (in the Team Assignment 2 worksheet) shows pertinent year-to-date data regarding the company's products.
Certain that the shortfall was caused by a lack of effort by the sales force, Michael has suggested to Lisa Boyle, the sales manager, that the company announce two contests to correct this situation before it deteriorates. The first contest is a trip to Hawaii awarded to the top salesperson if incremental glider sales are attained to close the budget shortfall. The second contest is a golf weekend, complete with a new set of golf clubs, awarded to the top salesperson if incremental sales of chairs with footstools are attained to close the budget shortfall. The Hawaiian vacation would cost $16,500 and the golf trip would cost $12,500.
Explain whether either contest is desirable or not. Supplement your analysis by determining the total contribution margin for Gliders and for Table-and-Chair sets under each of the following assumptions: actual sales volume at actual selling price, actual resource usage, and actual costs; and, actual sales volume at budgeted selling prices, budgeted resource usage, and budgeted costs.
Explain the strategic issues guiding your choice about these contests.
1. Explain whether either contest is desirable or not. Supplement your analysis by determining the total contribution m Gliders and for Table-and-Chair sets under each of the following assumptions: actual sales volume at actual selling usage, and actual costs; and, actual sales volume at budgeted selling prices, budgeted resource usage, and budge 2. Explain the strategic issues guiding your choice about these contests. Solution Data Glider Number of units Average sales price Variable costs Direct labor: Hours Cost/hour Direct material Sales commission Actual 2,600 $80.00 Budget 4,000 $85.00 2.50 $11.00 $16.00 $15.00 2.25 $10.00 $15.00 $15.00 Chair with Footstool Actual 6,900 $61.00 3.25 $9.50 ### ### Promotional activity costs: Hawaiian vacation = Golfing trip = Proposal analysis: First Contest: Gliders Per Unit Total Budgeted Sales Actual Sales Sales Shortfall Sales Value of Shortfall Direct material Direct Labor Rate Per Hour Direct Labor Hours Per Unit Direct Labor Cost Sales Commission Contribution Margin Cost Of Prize Excess of CM Over Cost Second Contest: Chair and Per Unit 4,000 $80 $16 $11 $2.50 $27.50 $15 $21.50 2,600 1,400 $112,000 $22,400 $38,500 $21,000 $30,100 $16,500 $13,600 $61 $11 $9.50 $3.25 $30.88 $10 $9.13 Based on Actual Sales and Actual Usage and Cost Data First contest: Gliders Per Unit Total Budgeted Sales Actual Sales Sales Shortfall Actual Sales Direct material Direct labor rate per hr Direct labor hrs per unit Direct labor cost Sales commission Contribution margin 4,000 2,600 1,400 $80 $16 $11 $2.50 $27.50 $15 $21.50 $208,000.00 $41,600.00 $71,500.00 $39,000.00 $55,900.00 Based on Actual Sales and Budgeted Usage and Cost Data: Ajia - Chair with Footstool Budget 8,000 $65.00 Table Actual 3,500 $24.00 3.00 $9.25 $10.00 $10.00 Budget 3,300 $25.00 0.60 $9.00 $6.00 $5.00 0.50 $9.00 $5.00 $5.50 $16,500 $12,500 Second Contest: Chair and Stool Total 8,000 6,900 1,100 $67,100 $12,100 $33,962.50 $11,000 $10,037.50 $12,500.00 -$2,463 Second contest: Chair and Stool Per Unit Total Total 8,000 6,900 1,100 $61 $11 $10 $3.25 $30.88 $10 $9.13 $420,900 $75,900 $213,037.50 $69,000 $62,962.50 $ 118,862.50 1. Explain whether either contest is desirable or not. Supplement your analysis by determining the total contribution m Gliders and for Table-and-Chair sets under each of the following assumptions: actual sales volume at actual selling usage, and actual costs; and, actual sales volume at budgeted selling prices, budgeted resource usage, and budge 2. Explain the strategic issues guiding your choice about these contests. Solution 1. Explain whether either contest is desirable or not. Supplement your analysis by determining the total contribution mar Gliders and for Table-and-Chair sets under each of the following assumptions: actual sales volume at actual selling p usage, and actual costs; and, actual sales volume at budgeted selling prices, budgeted resource usage, and budgete 2. Explain the strategic issues guiding your choice about these contests. Solution-1 Budgeted Sales Actual Sales Sales Shortfall Sales Value of Shortfall Direct material Direct labor rate per hr Direct labor hrs per unit Direct labor cost Sales commission Contribution margin Cost of Prize Excess of CM over cost First contest: Gliders Per Unit Total 4,000 2,600 1,400 $80.00 $112,000 $16.00 $22,400 $11.00 2.50 $27.50 $38,500 $15.00 $21,000 $21.50 $30,100 $16,500 $ 13,600 Second contest: Chair and Stool Per Unit $61.00 $11.00 $9.50 3.25 $30.88 $10.00 $9.13 Total 8,000 6,900 1,100 $67,100 $12,100 $33,963 $11,000 $10,038 $12,500 $ (2,463) Based on Actual Sales Volume, Actual Resource Usage, and Actual Cost Data Gliders Chair and Stool Per Unit Total Per Unit Total Total Budgeted Sales 4,000 8,000 Actual Sales 2,600 6,900 Sales Shortfall 1,400 1,100 Actual Sales Direct material $80.00 $16.00 $208,000 $41,600 $61.00 $11.00 $420,900 $75,900 1. Explain whether either contest is desirable or not. Supplement your analysis by determining the total contribution mar Gliders and for Table-and-Chair sets under each of the following assumptions: actual sales volume at actual selling p usage, and actual costs; and, actual sales volume at budgeted selling prices, budgeted resource usage, and budgete 2. Explain the strategic issues guiding your choice about these contests. Solution-1 Budgeted Sales Actual Sales Sales Shortfall Sales Value of Shortfall Direct material Direct labor rate per hr Direct labor hrs per unit Direct labor cost Sales commission Contribution margin Cost of Prize Excess of CM over cost First contest: Gliders Per Unit Total 4,000 2,600 1,400 $80.00 $112,000 $16.00 $22,400 $11.00 2.50 $27.50 $38,500 $15.00 $21,000 $21.50 $30,100 $16,500 $ 13,600 Second contest: Chair and Stool Per Unit $61.00 $11.00 $9.50 3.25 $30.88 $10.00 $9.13 Total 8,000 6,900 1,100 $67,100 $12,100 $33,963 $11,000 $10,038 $12,500 $ (2,463) Based on Actual Sales Volume, Actual Resource Usage, and Actual Cost Data Gliders Chair and Stool Per Unit Total Per Unit Total Total Budgeted Sales 4,000 8,000 Actual Sales 2,600 6,900 Sales Shortfall 1,400 1,100 Actual Sales Direct material $80.00 $16.00 $208,000 $41,600 $61.00 $11.00 $420,900 $75,900Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started