Problem 3 Problem 3. Super Bowl viewing figures are given for the years 2015 through 2022:Viewerstime tYear(millions)123456783.1 Which forecast is more accurate usingthe Mean Absolute Deviation (MAD).3.2 Which forecast is more accurate usingthe Mean Squared Error (MSE)20152016201720182019Use the above data to forecast the number of viewers for the years 2018 through 2022 usingboth the naïve and the 3-year moving average; then calculate the MAD and MSE forecast errorfor each to answer the following questions.3.3 Enter the values for MAD and MSEthat you calculated (no decimals needed -round to nearest whole number)202020212022MADMSE114.44111.86111.32103.3998.19100.4591.6399.18NAIVEMOVING AVG

time tYearViewers(millions)1201511422016112320171114201810352019986202010072021928202299

Answered: Super Bowl viewing figures are given…

Super Bowl viewing figures are given for the years 2015 through 2022: Viewers time t Year (millions) 1 2 3 2015 2016 2017 114.44 111.86 111.32

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Month Item 1 Item 2 Item 3 Item 4 1 751 250 666 287 2 741 268 618 352 3 728 289 483 416 4 773 314 375 313 5 718 337 303 359 6 752 367 242 440 7 736 391 210 520 8 768 409 239 391 9 729 433 342 449 10 777 459 396 550 11 748 481 457 650 12 756 500 587 489 Make a demand forecast for the next six periods for each item using any method you wish. What are the differences between qualitative and quantitative types of forecasting methods?
Question 3 To keep up with the market demands, Dolphin Technologies allows overtime for each of the two departments. The cost per hour of overtime for the Chip Manufacturing Department is $20, and $12 for Case Fabricating Department. Formulate a linear programming model can be used to determine the optimal production quantities if overtime is made available.
In early 20X1, Tech PC, a computer manufacturer, signed a contract with Forward University to ship 300 computers for a total price of CU 600,000(2,000 CU per computer). Due to the necessary preparatory work, Forward University agreed to ship computers in 3 separate shipments over the next 3 months (100 computers in each shipment). Maju Jaya Universityacquire control of the computer during delivery (FOB Shipping point). After the first shipment was made, Maju Jaya University and Tech PC changed the contract. Tech PC will supply an additional 200 computers (500 total). Price for an additional 200 computers agreed to be CU 280,000, to CU 1,400 per computer after a 30% discount. Tech PC provides a 30% discount for additional shipping because it hopes to collaborate with Maju Jaya University in the future. As of December 31, 20X1, Tech PC has shipped 400 computers (300 computers as initially agreed and 100 computers under contract amendment). Based on the above case, answer the following…
1. The drug distribution company LOS PAISAS wants to build a new warehouse in Carretera a Masaya area in which they intend to store the following products: equipment and products for babies. With these products, they plan to serve a total of 10,000 pharmacies in Managua. Equipments Baby products Demand (quantity pharmacies served) 2,000 8,000 Cost per product $1,000.00 $30.00 To achieve balanced use of products, baby product must be equal to 60% of authorized product units. Additionally, the number of units requested in medical equipment must be at least 20% of the total authorized. There are a total of 10,000 pharmacies. The optimal plan needs to be determined to maximize the amount of products they must have to meet demand and maximize profits. Can you please explain it Step-by-step and typed? Thank you in advance!
7
QUESTION 12 A vendor for the local ballpark food stand is questioning whether to stock his concession with a large or small inventory. He believes that it will depend upon the size of the crowd. He has developed a payoff matrix for the various alternatives (stocking decision) and states of nature (size of crowd). What is the answer using the criterion of maximin? Alternatives Large Inventory Small Inventory Probability OA) -$2,000 O B) $0 OC) $51,667 OD) $220,000 O E) -$5,000 Large Crowd $220,000 $90,000 .20 PROFIT (S) Average Crowd $50,000 $70,000 1.50 Small Crowd -$2,000 -$5,000 30
Module 5 Question 8 Mayborn Enterprises, LLC runs a number of sporting goods businesses and is currently analyzing a new T-shirt printing business. Specifically, the company is evaluating the feasibility of this business based on its estimates of the unit sales, price per unit, variable cost per unit, and fixed costs. The company's initial estimates of annual sales and other critical variables are shown here: Base CaseUnit sales 7,500Price per unit $16.00Variable cost per unit $10.00Fixed cash expense per year $10,000Depreciation expense $4,000 a. Calculate the accounting and cash break-even annual sales volume in units. b. Bill Mayborn is the grandson of the founder of the company and is currently enrolled in his junior year at the local state university. After reviewing the accounting break-even calculation done in part a, Bill wondered if the depreciation expense should be included in the calculation. Bill had just completed his first finance class…
Question 4 Carefully explain what is happening in the following markets. Indicate the impact if any on demand, supply, price and quantity Scenario 1: Market for 21 ft Ladders $21 FoOT LADDER RENTALS Fa BORDER FENCE OPE SCON Impact on demand Choose. Impact on supply Choose. Impact on price Choose. Impact on quantity Choose.
E-procurement Module Question 1 Mark is thinking of changing the entire business process by adopting the use of technology as it is the new trend in the business environment. He is inspired by a close friend who has been able to reduce the time spent at work and greater efficiency in operations. However, Mark has fear that adoption of e-procurement might not be an easy task for his new business. Advice Mark on the benefits associated with adoption of e-procurement that will help him overcome the fear. Explore challenges that Mark may be exposed to by adopting and implementing e-procurement.
Question 2 Rohe (Hong Kong) Ltd is a pharmaceutical company which manufactures and supplies various drugs for drug stores in Asia. Currently, Rohe (Hong Kong) Ltd has four factories A, B, C and D. Management has decided to build a new factory at a location central to these factories. Information regarding the yearly demands and the map coordinates for the four factories are shown in below table. Factories Demand - x-coord 9,000- 3,000- 5,000 y-coord 130 40 A Be 20 60 Ce 70 100 De 16,000- 90 30 (a) Determine the map coordinates of the new factory. (b) Suggest and elaborate TWO other factors that need to consider in the selection of location. «
QUESTION 4 Penske logistics transports fresh goods, baked goods, dairy, frozen, and merchandise to restaurants. When considering the physical nature of goods, discuss the factors that affect the mode of transport chosen. QUESTION 5 Elaborate on the steps that QSR would take to formulate a new strategy.