Answers
Level production plan
Formula
Chase capacity plan
Formula
Level capacity plan is recommended as it is producing lower cost
B H 1 Level production strategy 2 Quarter Time required(HOUR) Workers required Hire Layoff 3000 7000 Demand Regular production Ending Inventory Backlog 5000 1 24000 26000 7000 2 36000 26000 3 30000 26000 0 4 14000 26000 5000 104000 12000 Total Per unit 4800 0.4 20000 600 1400 13000 13000 13000 13000 52000 8 Total 10000 100 10 Inventory carrying cost 11 Backlog cost 12 Hire cost 13 lay off cost 14 15 Total 24800 16
DE F H 1 Level production strategy 2 Quarter Demand Regular production Time required(HOUR) Workers required Hire Layoff 3 4 1 5 2 63 7 4 8 Total 0 24000 36000 30000 14000 Ending Inventory Backlog 5000 7000 3000 7000 5000 =SUM(D4:07) SUM(E4:E7) 26000 26000 26000 26000 =SUM(C4:07) Per unit 0.4 =C4*(30/60) C5*(30/60) =C6*(30/60) =C7*(30/60) -SUM(F4:F7) =F4/(65*8) =F5/(65*8) =F6/(65*8) =F7/(65*8) =SUM(G4:G7) 0 =SUM(H4:47) =SUM(14:17) 9 10 Inventory carrying cost 11 Backlog cost 12 Hire cost 13 lay off cost Total =D8*C10 =E8*C11 =H8*C12 =18*C13 600 1400 14 15 Total 16 =SUM(B10:B13)
G H I Time required(HOUR) Workers required Hire Layoff 12000 18000 15000 7000 52000 23.07692308 0 34.61538462 11.53846 28.84615385 05.769231 13.46153846 0 15.38462 100 11.53846 21.15385 E 1 Chase production strategy Quarter Demand Regular production Ending Inventory Backlog 5000 1 24000 24000 5000 2 36000 36000 5000 3 30000 30000 5000 4 14000 14000 5000 8 Total 104000 20000 Total Per unit 10 Inventory carrying cost 8000 0.4 11 Backlog cost 12 Hire cost 6923.08 13 lay off cost 29615.4 1400 14 15 Total 44538.5 16 17 600
Demand Regular production Backlog Time required(HOUR) Workers required Hire Layoff 24000 36000 30000 14000 =G5-G4 Ending Inventory 5000 5000 5000 5000 5000 =SUM(D4:07) =B4 =B5 =B6 =B7 =SUM(C4:07) Per unit 0.4 =C4*(30/60) C5*(30/60) =C6*(30/60) =C7*(30/60) =SUM(F4:F7) =F4/(65*8) =F5/(65*8) =F6/(65*8) =F7/(65*8) =SUM(G4:47) =G5-G6 =G6-67 =SUM(14:17) =SUM(E4:E7) 1 Chase production strategy 2 Quarter 3 4 1 5 2 6 3 74 8 Total 9 10 Inventory carrying cost 11 Backlog cost 12 Hire cost 13 lay off cost 14 15 Total 16 =SUM(H4:H7) Total =D8*C10 =E8*C11 =H8*C12 =18*C13 600 1400 =SUM(B10:B13)
.
Similar Solved Questions
1 answer
A researcher theorized that people can hear better when they have just eaten a large meal
A researcher theorized that people can hear better when they have just eaten a large meal. Six individuals were randomly assigned to eat either a large meal or a small meal. After eating the meal, their hearing was tested. The hearing ability scores (high numbers indicate greater ability)(t test cha...
1 answer
The following table summarizes yields to maturity on several 1-year, zero-coupon securities: Security Yield ecur Treasury...
The following table summarizes yields to maturity on several 1-year, zero-coupon securities: Security Yield ecur Treasury АAА Сoгрoгate ВBB Coгporate 2.910% 3.522% 4.341% B Corporate 5.210% a. What is the price (expressed as a percentage of the face va...
1 answer
Please show all work and write neatly so I can understand how to do this on my own. Thank you. The transfer function of the given physical system is 2500 Gp(s)- P21000 The physical system is controll...
Please show all work and write neatly so I can understand how to do this on my own. Thank you. The transfer function of the given physical system is 2500 Gp(s)- P21000 The physical system is controlled with a unity-feedback system shown below, E(s) R(s) + (a) Draw the bode plot of open-loop transfe...
1 answer
How do you use synthetic substitution to find x=-3 for # f(x)= -x^4+x^3-x+1#?
How do you use synthetic substitution to find x=-3 for # f(x)= -x^4+x^3-x+1#?...
1 answer
Question 44 2 pts A newly admitted client has orders to receive 1,000 mL of normal...
Question 44 2 pts A newly admitted client has orders to receive 1,000 mL of normal saline IV over 8 hours. If the IV infusion set is a microdrip set that delivers 60 drops/mL, how many drops/minute should the nurse administer to the client? HTML Edit E = Ex x...
1 answer
Suppose Intel stock has a beta of 1.6 , whereas Boeing stock has a beta of...
Suppose Intel stock has a beta of 1.6 , whereas Boeing stock has a beta of 0.96 . If the risk-free interest rate is 4.7 % and the expected return of the market portfolio is 13.9 % , according to the CAPM, a. What is the expected return of Intel stock? (Round...
1 answer
6. Write the equation for the following graph. (Assume a = 1) 7. Solve forx. v...
6. Write the equation for the following graph. (Assume a = 1) 7. Solve forx. v gy- 3y = 13 2,-5)...
1 answer
HQ7.45 Homework . Unanswered Identify the period 2 element from the following ionization energies. IE, 13.6...
HQ7.45 Homework . Unanswered Identify the period 2 element from the following ionization energies. IE, 13.6 eV IE, 35.1 ev TE IE 54.9 ev 77.4 eV TE IE IE, E 113.4 eV 138.1 eV 739.3 eV 871.4 eV...
1 answer
Asap clearly pls Chapter 18 For each of the following independent situations, assume that any amounts...
asap clearly pls Chapter 18 For each of the following independent situations, assume that any amounts would be material (1) Indicate the TYPE of appropriate audit report; A. unqualified, B. qualified or adverse, C. qualified or disclaimer, D. Disclaimer, E. Qualified only, or F. Other. INDICATE t...
1 answer
The decomposition reaction: 2N2O5 (g) --> 4 NO2 (g) + O2 (g) has a rate constant...
The decomposition reaction: 2N2O5 (g) --> 4 NO2 (g) + O2 (g) has a rate constant kr = 0.1217 hr^–1 A reaction vessel of fixed volume is first evacuated and then filled with N2O5 to an initial pressure of 1.00 atm. The decomposition reaction is then initiated. (a) What are the partial pressu...
1 answer
Dr. McKusick directed Susan Hsu to contact Henrietta's children for blood samples to further HeLa research;...
Dr. McKusick directed Susan Hsu to contact Henrietta's children for blood samples to further HeLa research; neither McKusick nor Hsu tried to get informed consent for this research. Discuss whether or not you think this request was ethical. Further, think about John Moore and the patent that had...
1 answer
Homework: P2 (Financial Statements) Score: 0 of 1 pt 4 of 8 (2 complete) P2-7 (similar...
Homework: P2 (Financial Statements) Score: 0 of 1 pt 4 of 8 (2 complete) P2-7 (similar to) HW Score: 25%, 2 Question Help . Complete the partial inco Income statement. Use the data from the following financial statement in the popup window, statement if the co Complete the incoli Data Table Sales re...
1 answer
The top 10 cm of a forest soil in VT has a bulk density of 1.2...
The top 10 cm of a forest soil in VT has a bulk density of 1.2 g/cm3 and 20 centimoles of charge from exchangeable Ca2" per 1 kg of soil. There is 500 kg of Ca2* per hectare in the trees. If the trees are cut and removed, will there be enough calcium in the top 10 cm to regrow the forest (assume...
1 answer
1. A hoop of wire in the shape of a circle of radius RAs mounted vertically and rotates at constant angular speed w abo...
1. A hoop of wire in the shape of a circle of radius RAs mounted vertically and rotates at constant angular speed w about a vertical axis through its center. A bead with the mass of m moves smoothly on the wire. Find the equilibrium positions and discuss their Stabili when we neglect the damping eff...
1 answer
Question attached, thanks An IR spectrum was collected for an unknown organic molecule. The spectrum showed...
Question attached, thanks An IR spectrum was collected for an unknown organic molecule. The spectrum showed several peaks, which have been listed below. Peak 1 = 3039 Peak 2 = 2875 Peak 3 = 1665 Peak 4 = n/a Given this data, which of following was the unknown organic molecule? Please use this ta...
1 answer
This needs to be coded for diagnosis for ICD-CM-10. There are nine separate codes needed for...
This needs to be coded for diagnosis for ICD-CM-10. There are nine separate codes needed for the correct answer. HILLSIDE HOSPITAL 359 Mountain Pass Road Langston, FL 33993 DISCHARGE CLINICAL RESUME PATIENT DATE OF ADMISSION: DATE OF DISCHARGE: WYLER, WENDY 11/05/18 11/18/18 This is a 36-37-week tem...
1 answer
5. Larry Matt completed these transactions during December of the current year: Dec. 1 Began a...
5. Larry Matt completed these transactions during December of the current year: Dec. 1 Began a financial services practice by investing $15,000 cash and office equipment with a $5,000 value. 2 Purchased $1,200 of office equipment on credit. 3 Purchased $300 of office supplies on credit. Completed wo...