Please Help with Calculations
Problem1 Burdell Labs is a diagnostic laboratory that does various tests blood tests,urine tests,etc. for doctors offices in the Indianapolis area.Test specimens are picked up at the doctors'offices and are transported to the testing facility.with uniform arrivals throughout the day.All tests go through two testing centers in the testing facility,Test Center A and Test Center B.A has a current capacity of 1,000 units per week,and B is capable of 1,800 units per week.The facility operates 50 weeks per year.This yearyear 0,test demand through year 5i.e.,1,300 per week in year #1,1,600 per week in year #2,etc.).Pre-tax profits are expected to be $5 per test throughout the 5-year planning period.The following 2-step expansion plan is being considered: First,expand Test Center A at the end of year 0 to 1,800 units per week,matching Test Center B,at a cost of $150,000,and then Expand both Test Centers to 2,500 units per year at the end of year 3,at an additional cost at that time of $400,000. Use a discount rate of 15% Show all the calculations in the tables below before answering the multiple-choice questions. Without these calculations, correct answers may not receive full points.The shown work will help me see where the error is and provide appropriate partial credit and feedback.
What are the ideas to keep in mind? 1. Base case is do nothing-not to expand;if we don't expand,we can only sell as much as in year 0 2.So,we are looking at the additional cost (outflow and additional profit (inflow from making the expansion decision.(Compared to what we can sell in year 0) 3.We can't sell more than the demand. 4.We can't make (or sell)more than the capacity 5. Net present value: since the costs and benefits are over 6 years years 0 to 5,we should convert all the future outflows and inflows to year Q dollar value before we can make a decision.
Units/Week
Weekly Capacity at Test A
Weekly Capacity at Test B
Weekly Output for Lab
Additional output compared to base year (year 0)
Weekly Demand
Year 0 1 2 3 4 5
$for year50 weeks Additional Inflow Total Flow ($) (S)
Year Additional Outflow($) 0
NPV Y0$
2 3 4 5
