PROD 315 Summary Assignment 3 - Capacity Management Due 11:59 pm on Friday, February 15 Problem 1 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. The current capacity of the facility is 1,000 units per week. The facility operates 50 weeks per year. This year (year O), test volumes are expected to reach 1,000 units per week. Growth per week is projected at an additional 200 units through year 5 (i.e., 1,200 per week in year #1, 1,400 per week in year #2, etc.). Pre-tax profits are expected to be $5 per test throughout the 5-year planning period. The following expansion plan is being considered: o Expand the capacity at the end of year 0 to 1,500 units per week at a cost of $100,000 Then expand the capacity to 2,000 units per year at the end of year 3, at an additional cost at that time of $250,000. Use a discount rate of 15%. Use the table below to summarizes and calculate. You can copy the table on Excel, do your calculation using Excel, and copy it back here. Answers the questions below the table. Units per week $$ per year Weekly Demand Year Additional output per week Weekly Capacity Additional Outflow Additional Inflow Total NPV 1. What is the net present value of the additional pre-tax cash flow for year 0 alone? a. negative pre-tax cash flow b. more than $0 but less than $50,000 C. more than $50,000 but less than $100,000 d. more than $100,000 2. What is the net present value of the additional pre-tax cash flow for year 1 alone? a. negative pre-tax cash flow b. more than $0 but less than $50,000 c. more than $50,000 but less than $100,000 d. more than $100,000 3. What is the net present value of the additional pre-tax cash flow for year 3 alone? a. negative pre-tax cash flow b. more than $0 but less than $50,000 c. more than $50,000 but less than $100,000 d. more than $100,000 4. What is the net present value of the additional pre-tax cash flow for the next 5 years? a negative pre-tax cash flow b. more than $0 but less than $50,000 c. more than $50,000 but less than $100,000 d. more than $100,000 Problem 2 Sleep Tight Motel has the opportunity to purchase an adjacent plot of land. Building on this land would increase their capacity from the current sales level of $515,000/year to $600,000/year. Sleep Tight experiences a 20 percent before-tax profit margin. It wishes to estimate the additional before-tax profits that the expansion will produce. (You can copy this table to Excel to make your calculations.) Capacity Requirement (Annual Year Sales) $515,000 $517,000 $520.000 $525,000 $540,000 $560,000 $565,000 $575,000 9 $600,000 $620,000 10 L 1. How much more (additional) before-tax cash flow would be realized in year 6 alone due to this expansion? 2. Using the following information, how much more (additional) before-tax cash flow would be realized in year 10 alone due to this expansion? 3. Using the following information, how much more (additional) before-tax cash flow would be realized in the next 10 years due to this expansion? PROD 315 Summary Assignment 3 - Capacity Management Due 11:59 pm on Friday, February 15 Problem 1 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. The current capacity of the facility is 1,000 units per week. The facility operates 50 weeks per year. This year (year O), test volumes are expected to reach 1,000 units per week. Growth per week is projected at an additional 200 units through year 5 (i.e., 1,200 per week in year #1, 1,400 per week in year #2, etc.). Pre-tax profits are expected to be $5 per test throughout the 5-year planning period. The following expansion plan is being considered: o Expand the capacity at the end of year 0 to 1,500 units per week at a cost of $100,000 Then expand the capacity to 2,000 units per year at the end of year 3, at an additional cost at that time of $250,000. Use a discount rate of 15%. Use the table below to summarizes and calculate. You can copy the table on Excel, do your calculation using Excel, and copy it back here. Answers the questions below the table. Units per week $$ per year Weekly Demand Year Additional output per week Weekly Capacity Additional Outflow Additional Inflow Total NPV 1. What is the net present value of the additional pre-tax cash flow for year 0 alone? a. negative pre-tax cash flow b. more than $0 but less than $50,000 C. more than $50,000 but less than $100,000 d. more than $100,000 2. What is the net present value of the additional pre-tax cash flow for year 1 alone? a. negative pre-tax cash flow b. more than $0 but less than $50,000 c. more than $50,000 but less than $100,000 d. more than $100,000 3. What is the net present value of the additional pre-tax cash flow for year 3 alone? a. negative pre-tax cash flow b. more than $0 but less than $50,000 c. more than $50,000 but less than $100,000 d. more than $100,000 4. What is the net present value of the additional pre-tax cash flow for the next 5 years? a negative pre-tax cash flow b. more than $0 but less than $50,000 c. more than $50,000 but less than $100,000 d. more than $100,000 Problem 2 Sleep Tight Motel has the opportunity to purchase an adjacent plot of land. Building on this land would increase their capacity from the current sales level of $515,000/year to $600,000/year. Sleep Tight experiences a 20 percent before-tax profit margin. It wishes to estimate the additional before-tax profits that the expansion will produce. (You can copy this table to Excel to make your calculations.) Capacity Requirement (Annual Year Sales) $515,000 $517,000 $520.000 $525,000 $540,000 $560,000 $565,000 $575,000 9 $600,000 $620,000 10 L 1. How much more (additional) before-tax cash flow would be realized in year 6 alone due to this expansion? 2. Using the following information, how much more (additional) before-tax cash flow would be realized in year 10 alone due to this expansion? 3. Using the following information, how much more (additional) before-tax cash flow would be realized in the next 10 years due to this expansion