Bus309: Excel

2. The quarterly sales for specific educational software over the past three years are given in the following table. a) Compute the four seasonal factors per quarter. b) What is the demand forecast per quarter in year 4 if the total forecast for the year (4) is 8,000?

AutoSave OFF O . .. Individual Course Project SP2023 (1) ~ Home Insert Draw Page Layout Formulas Data Review View Automate Developer New Tab Tell me Comments Share Calibri (Body) 11 A A Conditional Formatting v Format as Table v Paste BIUV A Alignment Number Cells Editing Analyze Automate Reference Translator Solver Cell Styles v Data Content A19 X V fx D E G H M N O Q R Chapter 4 - Forecasting (10 Pts) The quarterly sales for specific educational software over the past three years are given in the following table. a) Compute the four seasonal factors per quarter. b) What is the demand forecast per quarter in year 4 if total forecast for the year (4) is 8,000? Avg. Avg. YEAR 1 YEAR 2 YEAR 3 Period Sea Fact Demand 10 Demand 11 Quarter 1 1,710 1,820 1,830 1,787 2,000 0.89 12 Quarter 2 960 910 1,090 187 2,000 0.49 13 Quarter 3 2,720 2,840 2,900 2,820 2,000 1.41 14 Quarter 4 2,430 2,200 2,590 2,407 2,000 1.20 15 2,000 16 17 18 19 20 Instructions Q1-Ch3 Q2-Ch4 Q3-Ch8 Q4-Ch14 Q5-Ch16 Q6-Ch17 Q7-ModA Q8-ModB Q9-ModD Q10-ModF + Ready Accessibility: Investigate + 100%AutoSave OFF O . .. Individual Course Project SP2023 (1) ~ Home Insert Draw Page Layout Formulas Data Review View Automate Developer New Tab Tell me Comments Share Calibri (Body) 11 A A Conditional Formatting v Format as Table v Paste BIUV A Alignment Number Cells Editing Analyze Automate Reference Translator Solver Cell Styles v Data Content B16 X V fx C D E F G H K M N O P Q R Chapter 8 - Location Strategies (5 Pts) A manufacturing firm is considering three potential locations for a new parts manufacturing facility. A consulting firm has assessed three sites based on the four factors supplied by management as critical to the location's success. Given the management-supplied factor weights and the consultant team scores, which location should be selected? Scores are based on 50 = best. 8 Location 9 Factor Weight A B C 10 Labor Climate 10 35 15 20 11 Taxes 30 30 40 40 12 Utilities 20 25 20 45 13 Wages 40 10 25 25 14 15 16 17 18 19 20 25 26 27 28 Instructions Q1-Ch3 Q2-Ch4 Q3-Ch8 Q4-Ch14 Q5-Ch16 Q6-Ch17 Q7-ModA Q8-ModB Q9-ModD Q10-ModF + Ready Accessibility: Investigate + 110%AutoSave OFF O . .. Individual Course Project SP2023 (1) ~ Home Insert Draw Page Layout Formulas Data Review View Automate Developer New Tab Tell me Comments Share Calibri (Body) 11 A A Conditional Formatting v Format as Table v Paste BIUV A Alignment Number Cells Editing Analyze Automate Reference Translator Solver Cell Styles v Data Content G12 X V fx C D E F G H K M N O P Q R T Chapter 14 - Material Requirements Planning (10 Pts) There is one order outstanding, to make 80 frame kits. There are 200 legs in inventory. There are no other large items in inventory, and no scheduled receipts. Fasteners are available from the small parts area. 5 Calculate the gross and net requirements to fulfill the outstanding order (fill in the blanks). A-frame 10 Ridge pole Side braces 12 (2) Legs (4) (1) 13 14 Fastener set Fastener set 15 (2) (1) 16 17 Gross On-hand Net Par 18 Requirements Inventory Requirements 19 A-frame 80 Ridge 20 pole Side 21 braces 22 Legs 200 Fastener 440 23 set 24 25 26 27 28 Instructions Q1-Ch3 Q2-Ch4 Q3-Ch8 Q4-Ch14 Q5-Ch16 Q6-Ch17 Q7-ModA 28-ModB Q9-ModD Q10-ModF + Ready Accessibility: Investigate + 100%Q AutoSave .orr ' 9 v {F} 2;; !l G) a Individual Course Project SP2023 (1)v Home Insert Draw Page Layout Formulas Data Review View Automate Developer New Tab Q Tell me [ Calibri (Body) 11 B I U v A A / v [II Conditional Formatting v Egg v p v 3" I v v 4 Format as Table v v ' (I; v A V Alignment Number Editing Analyze Automate Reference Translator Solver W Cell Styles v Data Content _l_ Discount Mart, a major East Coast retailer, wants to the determine the economic order quantity (see Chapter 12 for E00 formulas) for its halogen lamps. It currently buys all halogen lamps from Specialty Lighting Manufacturers in Atlanta. Annual demand is 2,000 lamps, ordering cost per order is $30, and annual carrying cost per lamp is $12. a) What is the E00? b) What are the total annual costs of holding and ordering (managing) this inventory? c) How many orders should Discoun Mart place with Specialty Lighting per year? Q5-Ch16 Instructions Q1 -Ch3 QZ-Ch4 7 7 78' Q4-Ch14 33 7;? Accessibility: investigate QS-Ch17 Q7ModA QQ-ModD Q10-ModF + @ E -( )+1oo% Ready Q AutoSave .orr ' 9 v {F} 2;; !l G) a Individual Course Project SP2023 (1)v Home Insert Draw Page Layout Formulas Data Review View Automate Developer New Tab Q Tell me [ Calibri (Body) 11 B I U v A A / v [II Conditional Formatting v Egg v p v 3" I v v 4 Format as Table v v ' (I; v A V Alignment Number Editing Analyze Automate Reference Translator Solver W Cell Styles v Data Content _[_ Number of breakdowns _ Monthl fre-uen _ Each time the system is down, the firm loses an average of $400 in time and service expenses. They are considering signing a contract for preventive maintenance. With preventive maintenance, the system would be down on average only 0.5 per month. The monthly cost of preventive maintenance would be $200 a month. Which is cheaper, breakdown or preventive maintenance? Why? Show your computations. Instructions Q1-Ch3 QZ-Ch4 7 ,B' 05-Ch16 33 7;? Accessibility: Investigate QG-Ch17 Q7ModA QQ-ModD Q10-ModF + @ E -( )+1oo% Ready