Sheet 9: Q8 Planning modelQ8. Usebelow tableto to find theprofit of thecompany,(productionplan is3000)Yslope250020005500 650007500 95000Unit price15.5Units3000Fixed cost19000Y(pkp)X(pkp)alopeVar cotsotal costSale

In the linear regression model, two variables are taken into considerations. X is the independent…

Answered: Sheet 9: Q8 Planning model Q8. Use…

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

Q2) 3. What is long range plan?
* 00 T 35 R Miles used the information on the table to develop a Decision Tree for this situation and indicate which type of truck should he select. What would Miles's decision be based on Baye's Decision Rule? $16,000 3. $19,000 2 $21,000 $15,000 .5 Compact 000'0 000 $24,000 2. Full-size .2 000 0 Subcompact Can't be determined with the information provided Compact All of the answer choices are correct Full size MacBook Air 000 000 DD F7 F2 F3 F5 F8 F4 & $ 9. 7. 4. J K
May 77.000 Problem 4 (Regression Analysis, Service Company) Bobby Gonzales owns a catering company that prepares banquets and parties for both individual and business functions throughout the year. Gonzales business is seasonal, with a heavy schedule during the summer months and the year-end holidays and a light schedule at other times. During peak periods there are extra costs. One of the major events Gonzales' customers request is a cocktail party. He offers a standard cocktail party and has developed the following cost structure on a per person basis. Food and bevernges Labor (0.5 hour x PIO per hour) Overhead (0.5 hour x P14 per hour) Total costs per person PI5.00 5.00 7.00 P27.00 Gonzales is quite certain about his estimates of the food, beverages, and labor costs but is not as comfortable with the overhead estimate. This estimate was based on the actual data for the past 12 months presented below. These data indicate that overhead costs vary with the direct labor- hours used. The…
Required information Lyndia Company is a merchandiser that sells a total of 15 products to its customers. The company provided the following information from last year: Selling Price Variable Cost Product 1 Unit Sales per Unit per Unit 9,000 $ 29 $12.95 2 16,500 $ 99 $68.55 3 6,000 $ 85 $42.50 4 19,500 $109 $85.00 5 4,500 $ 19 $ 6.35 6 27,000 $119 7 3,000 $ 39 $92.00 $14.30 8 7,500 $ 79 $33.18 9 9,000 $ 69 $30.36 10 15,000 $.95 $77.60 11 10,500 $ 59 $25.40 12 1,500 $ 65 $29.00 222 13 3,000 $ 44 $12.40 141 6,000 $ 49 $13.48 15 12,000 150,000 $ 89 $61.83 Last year, Lyndia's total fixed expenses and net operating income were $3,000,000 and $1,223,070, respectively. The company would like your assistance in developing some financial projections for this year.
Component Immediate Parent Usage per Parent Lead Time (weeks) Beginning Inventory A none — 1 0 B A 2 2 250 C A 1 6 500 D A 3 3 750 E A 2 2 750 F B 4 2 3000 G B 2 4 1000 H D 3 2 5000 I D 2 4 5000 J E 1 8 1000 K E 5 1 5000 L E 2 4 2500 M F 3 3 250 N F 6 3 2560 O H 2 4 0 P K 1 2 500 Q K 2 3 1000 Using the information given, calculate the replenishment time when no beginning inventory exists.
12. Determine the planned purchases for January (a) at retail and (b) at cost for the lingerie department when the seasonal merchandise plan indicates the following planned figures: Round to the nearest dollar. Sales $88,000 Markdowns 8% BOM Stock $81,000 EOM Stock $66,000 Markup 49%
Product A Order Qty = 400 Order Lead Time = 2 Forecast Demand Scheduled Receipts Projected Available Inventory 400 Planned Order Receipts Planned Order Releases 1 300 OD 4, 6, 2 300 400 Sketch and fill in the grid on scrap paper to use on upcoming questions In what periods would you incur a planned order release? OA 1.3, and 4 2.4, and 5 OC 3,5, and 6 and 7 3 300 PERIODS 4 300 5 300 6 300 7 100 8 100
Ch 11 Q7
QUESTION 2 When used effectively, S&OP Planning does not require cross-functional collaboration. O True False
Assistance for question 5 please
Scenario analysis allows a firm to ask what - if type questions in capital budgeting. Question 22Select one: True False
2. Discover ambiguities or omissions in the following statement of requirements for part ofa ticket-issuing system:An automated ticket-issuing system sells rail tickets. Users select their destination andinput a credit card and a personal identification number. The rail ticket is issued and themcredit card account charged. When the user presses the start button, a menu display ofpotential destinations are activated, along with a message to the user to select a destination.Once a destination has been selected, users are requested to input their credit card. Itsvalidity is checked and the user is then requested to input a personal identifier. When thecredit transaction has been validated; the ticket is issued.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

Sheet 9: Q8 Planning model Q8. Use below table to to find the profit of the company, (production plan is 3000) Y slope 0. 2000 5500 65000 7500 95000 2500 Unit price 15.5 Units 3000 Pixed cost 19000 Yokp) X(pkp) alopa Vat cost total cost