Question

In: Other

George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of...

George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats during each of the past four seasons was as follows: 

Season1234
Winter1,4401,2401,000960
Spring1,5001,4401,6401,540
Summer1,0002,1002,0402,000
Fall640750670520

George has forecasted that annual demand for his sailboats in year 5 will equal 6,500 sailboats. 

Based on the given data and using the multiplicative seasonal model, the demand level for George's sailboats in the spring of year 5 will be _______  sailboats (enter a whole number).

Solutions

Expert Solution

1. SPRING = 1814

EXPLANATION:

SEASON

1

2

3

4

WINTER

1440

1200

1040

960

SPRING

1560

1400

1620

1540

SUMMER

1000

2120

2020

1900

FALL

600

750

650

560

AVERAGE

1150

1367.5

1332.5

1240

AVERAGE 1 = 1440 + 1560 + 1000 + 600 / 4 = 1150

AVERAGE 2 = 1200 + 1400 + 2120 + 750 / 4 = 1367.5

AVERAGE 3 = 1040 + 1620 + 2020 + 650 / 4 = 1332.5

AVERAGE 4 = 960 + 1540 + 1900 + 560 / 4 = 1240



SEASON

1

2

3

4

AVERAGE SI

WINTER

1440 / 1150 = 1.25217391304348

1200 / 1367.5 = 0.877513711151737

1040 / 1332.5 = 0.780487804878049

960 / 1240 = 0.774193548387097

1.252173913 + 0.8775137112 + 0.7804878049 + 0.7741935484 / 4 = 0.9211

SPRING

1560 / 1150 = 1.35652173913043

1400 / 1367.5 = 1.02376599634369

1620 / 1332.5 = 1.21575984990619

1540 / 1240 = 1.24193548387097

1.356521739 + 1.023765996 + 1.21575985 + 1.241935484 / 4 = 1.2095

SUMMER

1000 / 1150 = 0.869565217391304

2120 / 1367.5 = 1.55027422303473

2020 / 1332.5 = 1.51594746716698

1900 / 1240 = 1.53225806451613

0.8695652174 + 1.550274223 + 1.515947467 + 1.532258065 / 4 = 1.367

FALL

600 / 1150 = 0.521739130434783

750 / 1367.5 = 0.548446069469835

650 / 1332.5 = 0.487804878048781

560 / 1240 = 0.451612903225806

0.5217391304 + 0.5484460695 + 0.487804878 + 0.4516129032 / 4 = 0.5024

ANNUAL SALES NEXT YEAR = 6000

AVERAGE SALES PER SEASON = 1500

ADJUSTED DEMAND

SEASON

1

CALCULATION

WINTER

1382

1500 * 0.9211 = 1382

SPRING

1814

1500 * 1.2095 = 1814

SUMMER

2051

1500 * 1.367 = 2051

FALL

754

1500 * 0.5024 = 754


Related Solutions

George Kyparisis owns a company that manufactures sailboats. Actual demand for​ George's sailboats during each of...
George Kyparisis owns a company that manufactures sailboats. Actual demand for​ George's sailboats during each of the past four seasons was as​ follows:                                                                                                             Year                                   Season 1 2 3 4 Winter 1 comma 4001,400 1 comma 2001,200 1 comma 0001,000 960960 Spring 1 comma 5601,560 1 comma 4201,420 1 comma 6401,640 1 comma 5801,580 Summer 1 comma 0001,000 2 comma 1002,100 2 comma 0402,040 1 comma 9601,960 Fall 600600 750750 650650 500500 George has forecasted that annual demand for his...
Voyage Sail Makers manufactures sails for sailboats. The company has the capacity to produce 36,000 sails...
Voyage Sail Makers manufactures sails for sailboats. The company has the capacity to produce 36,000 sails per year and is currently producing and selling 25,000 sails per year. The following information relates to current production: Sales price per unit $185​ Variable costs per unit: ​ Manufacturing $60​ Selling and administrative $20​ Total fixed costs: ​ Manufacturing $700,000​ Selling and administrative $300,000​ If a special pricing order is accepted for 5500 sails at a sales price of $160 per unit, and...
i need the solution with step plz Lowwater Sailmakers manufactures sails for sailboats. The company has...
i need the solution with step plz Lowwater Sailmakers manufactures sails for sailboats. The company has the capacity to produce 25,000 sails per year, but is currently producing and selling 20,000 sails per year. The following information relates to current production: Sale price per unit $150 Variable costs per unit:      Manufacturing $55      Marketing and administrative $25 Total fixed costs:      Manufacturing $640,000      Marketing and administrative $280,000 1.         If a special sales order is accepted for 5,000 sails...
Linear Programming Problem 1: George's Woodcarving Company manufactures two types of wooden toys: soldiers and trains....
Linear Programming Problem 1: George's Woodcarving Company manufactures two types of wooden toys: soldiers and trains. A soldier sells for $27 and uses $10 worth of raw materials. Each soldier manufactured increases George's variable labor and overhead costs by $14. A train sells for $21 and uses $9 worth of raw materials. Each Train built increases George's variable labor and overhead costs by $10. The manufacture of wooden soldiers and trains requires two types of skilled labor: carpentry and finishing....
The actual demand data for an item at a local retailer during the past six weeks...
The actual demand data for an item at a local retailer during the past six weeks are shown below: WEEK ACTUAL DEMAND (number of units) Six weeks ago 202 Five weeks ago 201 Four weeks ago 199 Three weeks ago 200 Two weeks ago 203 One week ago 198 THIS WEEK ACTUAL DEMAND NOT KNOWN Determine the demand forecast for THIS WEEK using each of the following methods: a. A 3-week moving average. [3] b. A 4-week weighted moving average...
A company has the following actual and standard production measures during the period:                 Actual units...
A company has the following actual and standard production measures during the period:                 Actual units produced    390                 Actual materials purchased and used      2,583 lbs                 Actual materials price     $9 per lb                 Actual labor hours           1430                 Actual labor rate               $21.4 per hour                 Actual variable overhead              $ 7,950                 Standard materials per unit         6 lbs                 Standard materials purchased and used $8.6 per lb                 Standard labor hours per unit     3                 Standard labor rate         $22.5 per...
Question 6 - Halsey Company makes small sailboats. During the most recent month, the following activity...
Question 6 - Halsey Company makes small sailboats. During the most recent month, the following activity was recorded in the Hull Fabrication Department for conversion costs. Work in process, beginning (80% complete)................. 15,000 units Units started into production............................................. 180,000 units Units transferred to the next department........................ 175,000 units Work in process, ending (30% complete)....................... 20,000 units Conversion Costs: Work in process, beginning............................................... $24,000 Conversion costs incurred during the month................. $338,000 Required Assuming that the company uses the weighted average method:...
George Company manufactures a check-in kiosk with an estimated economic life of 12 years and leases...
George Company manufactures a check-in kiosk with an estimated economic life of 12 years and leases it to National Airlines for a period of 10 years. The normal selling price of the equipment is $299,140, and its unguaranteed residual value at the end of the lease term is estimated to be $20,000. National will pay annual payments of $40,000 at the beginning of each year and all maintenance, insurance, and taxes. George incurred costs of $180,000 in manufacturing the equipment...
George Company manufactures a check-in kiosk with an estimated economic life of 12 years and leases...
George Company manufactures a check-in kiosk with an estimated economic life of 12 years and leases it to National Airlines for a period of 10 years. The normal selling price of the equipment is $299,140, and its unguaranteed residual value at the end of the lease term is estimated to be $20,000. National will pay annual payments of $40,000 at the beginning of each year and all maintenance, insurance, and taxes. George incurred costs of $180,000 in manufacturing the equipment...
George Company manufactures a check-in kiosk with an estimated economic life of 12 years and leases...
George Company manufactures a check-in kiosk with an estimated economic life of 12 years and leases it to National Airlines for a period of 10 years. The normal selling price of the equipment is $299,140, and its unguaranteed residual value at the end of the lease term is estimated to be $20,000. National will pay annual payments of $40,000 at the beginning of each year and all maintenance, insurance, and taxes. George incurred costs of $180,000 in manufacturing the equipment...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT