How do I this Excel problem? AI2345678910111213 Inputs14 Requirements per bookshelf15 Board-feet required161718 Labor hours required19 Current cost per board-foot20 Projected annual increase2122 Current cost per labor hour23 Projected annual increase2425 Projected costs26272829303132333435363738BExercise:1. Given the inputs below, fill in the projected costs in rows 28-34 with copyable formulas.Years from now01234562. Create a line chart on this sheet of the four series in columns G-J, with the following requirements:a. Chart type: Line with Markersb. Name the chart: Projected Costsc. Link the horizontal axis to Years from now for each seriesd. Title the chart: Project Costs per Bookshelfe. Name the horizontal axis: Years from Nowf. Start the vertical axis at $40033Cherry15$7.502.5%C$18.101.9%Cherry$7.50$7.69$7.88$8.08$8.28$8.49$8.70DOak Walnut17$5.101.9%15$6.101.7%ECost per board-footOak$5.10$5.23$5.36$5.49$5.63$5.77$5.91Walnut$6.10$6.25$6.41$6.57$6.73$6.90$7.07Teak17$7.502.4%TeakF$7.50$7.69$7.88$8.08$8.28$8.49$8.70Cost per hourLabor$272.50$272.50$272.50$272.50$272.50$272.50$272.50GCherry$6,968.50HICost per bookshelfOakWalnutJTeakKL

The costs and requirements for making a bookshelf are stated below:

Answered: 1. Given the inputs below, fill in the…

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

spaces between figures) * Your answer There are 2 policies suggested by Procurement related to inventories. Policy A suggests: Order 150 units. ROP is 50 units and the time between placing and receiving an order is 10days. Policy B suggests: Order 200 units. ROP is 75 units and the time between placing and receiving an order is 15days.Order cost is P20.00 per order and the cost of keeping inventory is P 0.02 per day. Which policy do you think is the best for the company to adopt and what is the cost. Policy A Policy B How much is the cost of production planning A using chase demand? Write your
Please do not give solution in image format thanku In 2018, the government of Ghana launched operation one district one factory (IDIE). Based on IDIF, Ekumfi Pineapple Factory Co. Ltd (EPF) was launched. In 2019 the management of ERF started production with 100 workers per shift, each of the three shifts working 8 hours per day. Every working day the payroll cost was GHIC 20,000 and overhead expenses amounted to GHC 5000 and material cost GHC 4000. At the end of the first year, the company produced 1,000,000 boxes of pineapple juice. During the second year, EPF acquired a loan from Exim Bank to purchase a new plant. After the introduction of the new plant, the management reduced the size of its workers per shift to 80, each working 8 hours per day, with the payroll cost reducing to GHC 18,000 and overhead expenses also reducing to GHC 4000 and material cost rising to GHC 6000. Production rose to 1,200,000 boxes. Regard yourself as the Operations Manager of EPF: a) What are the…
A method of estimating future demand usedfor decision making in order to set reasonable targets and control orlimit uncertainties or risks.
Explain briefly a) Efficient Production b) Inefficient Production c) What causes NPV to increase
Please do not give solution in image format thanku XYZ Mobile makes phones in multiple production lines. The daily production run is for 820 phones. Each phone has a standard time of 5.1 minutes. Each production line operates for 9 hours per day. Do not include commas in your answer and enter percentages as decilmal points. For example enter 1,402 as 1402 and 67.5% as 0.675. How many production lines are needed to meet the daily demand? What is the utilization of the production lines? What is the maximum daily output of the system?
at is the inventory turnover for last year? is at is is oved More Info Sales Cost of goods sold Gross margin Other expenses Net income Finished goods inventory Work-in-process inventory Raw material inventory Total inventory (average for year) Other current assets Other assets Total assets LAST YEAR $244,000 118,000 126,000 Done 51,000 75,000 0 2,000 9,500 4,000 15,500 90,000. 200,000 305,500 . THIS YEAR $257,000 130,000 127,000 51,000 76,000 4,500 12,000 5,500 22,000 109,000 244,000 375,000 - X
123456789unn3u5167 10 5 6 Variable Cells 18 19 20 21 22 23 24 25 26 27 28 29 30 31 7 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 8 9 10 11 2 11 13 12 14 12 Constraints Name Cell $B$15 demand for A LHS $B$16 total demand LHS 16 17 $B$17 procssing time LHS Cell $C$8 A $D$8 B 15 16 Name Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 1E+30 250 100 Final Value Price 250 350 600 0 0 Shadow Constraint R.H. Side 0 4 -1 2 3 Q1 what is the range for objective coefficient of A and B? 125 350 600 1 1E+30 Allowable Allowable Increase Decrease Q4) if the objective coefficient of A goes up to 5 dollars what will happen? Q2 assume that the final value of B is 0 and the reduced cost of B is 1; explain the situation ? Q5 If the objective coefficient of B goes up to 8 dollars what will happen? Q6) if the obj coeff of A goes down to -5 dollars what does that mean? 125 125 100 1 Q3 if the objective coefficient of A goes down to 1 dollar and objective coefficient of B…
5. For most ingredients, a recipe costing sheet could adjust the EP quantity to an AP quantity, using each ingredient's yield percentage, and then multi- ply the AP quantity by the AP cost to get the extended cost. Why can't a large cut of meat that 1. How might a restaurant attempt to control qualicy and portion sizes if it does not employ standard recipes? 2. One restaurant changes its menu daily to make use of seasonal products. Customers are rarely able to come back to the restaurant to experience the same dish twice. Is it important for this operation to employ standard recipes? How about standard por- tion sizes? Why or why not? 3. A mezze (Mediterranean tapas or small plates) res- taurant serves "free" bread to all of its customers. Because of the nature of the menu, however, there is no entrée course; all dishes are essentially small tast- ings. How might this restaurant account for the bread in the true cost per portion of its dishes? 4. Chefs who research recipes in cookbooks…
.Substitue for Mandatory problem #2 on exam in attachment )-Calculate the Tracking Signal(RSFE/MAD t) given the following data and an alpha=0.4.MAD t-1=15: Period Actual Demand Forecast Demand Error ................... RSFE MAD t TS 0 Start up Start Up Start Up 15 1 30 45 2 43 3 38 4 37 5 40
U-RIDE, Inc. currently produces the electric engines that are used in golf carts made and sold by the Company. Electco has offered to sell the electric engines to U-RIDE at a price of $277 each. Current production information follows: Unit-level material and labor 2$ 230 Facility-level depreciation of manufacturing equip. Product-level engine production supervisor's salary Annual facility-level utilities $ 6,100/month $ 3,100/month $20,500 Buying the engines will free up manufacturing capacity that could be used to make a new economy line golf cart that would produce an additional $11,600 profit per year. U-RIDE is currently operating profitably producing and selling 3,100 engines annually. Based on this information, which of the following is true? Multiple Choice The $111,600 is not relevant because it is an estimate. Buying the units would increase U-RIDE's cost by $35 per unit. of 10
3(AL Jn 2020, Square-Nine Entrerprise has purchased 250,000 micro-chips for the first four months and 35% more on the remainder as a component in the production of its products. As much as 25% of the purchase is not used but instead stored in the warehouse. Each unit of the final product is sold in the market at a price of $18.99 per unit, and the storage cost is a total of $1.13 per unit. The cost price of the order is $5,500 for each delivery that takes three weeks. Calculate: 1) An annual optimal order quantity. 2) A total of number of orders placed in a year. 3) Time range between orders if the company operates for 49 weeks in a year 4) What are total units for reorder point? 5) Cost of Goods Sold.
Answer 12.7a-c Please show detailed calculations or software output

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