Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed 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,900

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Financial Reporting And Analysis

Authors: S David Young, Jacob Cohen, Daniel A Bens

4th Edition

111949463X, 9781119494638

More Books

Students also viewed these Accounting questions

Question

Why are fixed costs depicted as a horizontal line on a CVP chart?

Answered: 1 week ago

Question

What are the major elements of design planning?

Answered: 1 week ago

Question

What do you like to do in your spare time?

Answered: 1 week ago

Question

Behaviour: What am I doing?

Answered: 1 week ago