Question

In: Operations Management

Please complete all work in excel. Use excel to make the calculations (cells can be clicked...

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units.

A firm has 82 units of a product on hand. Forecasts of demand are 30 units per week. An MPS quantity of 100 units is planned to arrive in period 3. Customer orders are 32 for period 1, 28 for period 2, and 25 for period 3. What is the projected on-hand inventory at the end of period 3?

Solutions

Expert Solution

Projected-on-hand inventory for end of period 3= Projected-on-hand inventory for end of period 2+MPS quantity-customer orders for period 2 or forecast of demand for period 2 (whichever is higher)

Initially firm has 82 units. Customer order is 32 and forecasts of demand are 30. So we will deduct 32 out of 82 to get projected on hand inventory for end of period 1. And similarly for future periods as follows:

Inventory on hand for end of period 1= 82-32=50.

Projected-on-hand inventory for end of period 2= 50-3=20

Projected-on-hand inventory for end of period 3=20+100-30=90

Projected on-hand inventory at the end of period 3 is 90

Please give an Up-vote, this will be quite encouraging for me, thank you! If you have any doubt, kindly comment. I would love to help you!!!


Related Solutions

Please complete all work in excel. Use excel to make the calculations (cells can be clicked...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. The manager of QuikStop (open 365 days a year) sells 40 cases of water each day. Order costs are $30 per order, and water costs $0.10 per bottle (each case of water contains 24 bottles). Daily holding costs are equal to 3 percent of the cost of the water....
Please complete all work in excel. Use excel to make the calculations (cells can be clicked...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. Activity Immediate Predecessor Activity Time (wks) Total Budgeted Cost A - 4 24,000 B - 5 15,000 C A 2 16,000 D B 8 40,000 E C 3 30,000 F D, E 5 55,000 G F 3 21,000 H D 7 21,000 I F 5 10,000 J G, H...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. There are four jobs to be done and four employees to do them. Each resource will take a specific time, translated to salaries, to do each job, as shown in the following table: Employee Job A B C D 1 $20 23 21 17 2 18 18 22 19...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
Please show complete work and all calculations Using the following information for a population of data...
Please show complete work and all calculations Using the following information for a population of data points X : n=30 =5   2 =4 ( population variance) A) What is the distribution of the population of sample means? B) Find the probability that the sample mean is less than 4 ?
Please complete the following problems. Please explain and show your work for all calculations: You intend...
Please complete the following problems. Please explain and show your work for all calculations: You intend to purchase a 10-year, $1,000 face value bond that pays interest of $60 every six months. If the yield to maturity is 10% with semiannual compounding, how much should you be willing to pay for this bond? A ten year bond with a coupon rate of 12% (payable annually) and a face value of $1,000 is selling for $1,192.50 today. What is the bond’s...
Use Excel to complete the following question. You must submit/attach all work done in Excel in...
Use Excel to complete the following question. You must submit/attach all work done in Excel in order to receive full credit. 5. A health advocacy group conducted a study to determine if the nicotine content of a particular brand of cigarettes was equal to the advertised amount. The cigarette brand advertised that the average nicotine content per cigarette was 1.4 milligrams. The advocacy group randomly sampled 24 cigarettes. The nicotine level for each of the sampled cigarettes is given below....
Please make sure to complete all parts of the question and to show all work used...
Please make sure to complete all parts of the question and to show all work used to compute the answer so I can see how the answer was found. A five-year annuity of 10 $5,230 semiannual payments will begin nine years from now, with the first payment coming nine and a half years from now. If the discount rate is 10 percent compounded monthly, what is the value of this annuity five years from now? What is the value three...
Please use excel and show all work and formulas. (I will give your work a like...
Please use excel and show all work and formulas. (I will give your work a like if you do this) Size (1000s sq. ft) Selling Price ($1000s) 1.26 117.5 3.02 299.9 1.99 139.0 0.91 45.6 1.87 129.9 2.63 274.9 2.60 259.9 2.27 177.0 2.30 175.0 2.08 189.9 1.12 95.0 1.38 82.1 1.80 169.0 1.57 96.5 1.45 114.9 What are the p-values of the t test (for the slope estimate) and F test? What is the coefficient of determination? What is...
PLEASE SOLVE IN EXCEL WITH CALCULATIONS AND WORK. A mortgage for $100,000 is made with initial...
PLEASE SOLVE IN EXCEL WITH CALCULATIONS AND WORK. A mortgage for $100,000 is made with initial payments of $500 per month for the first year. The interest rate is 9 percent. After the first year, payments will increase to an amount that makes the loan fully amortizable over the remaining 24 years with constant monthly payments. a. Calculate the interest deductions for the loan for the first year. b. How much, if any, interest must be deferred until the second...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT