PLEASE SHOW STEPS AND ANSWER THE WHOLE QUESTION

I NEED STEPS OF HOW TO DO IT IN EXCEL

PLEASE SHOW STEPS AND ANSWER THE WHOLE QUESTION :

I NEED STEPS OF HOW TO DO IT IN EXCEL

Case Study 2.4.4 Tony's Lamb Holuse is a distributor of gourmet lamb shanks. It imports lamb shanks at the beginning of every quarter from Australia, New Zealand, and China. It currently rents a warehouse with a capac- ity to store 200,000 lb of lamb shanks. The demand for lamb shanks has increased steadily over the past 3 years, as shown in Table 2.12. TABLE 2.12 Demand of Lamb Shank (in lb) at Tony's Lamb House New Zealand Quarter Australia China Total 1 2 3 4 5 6 26,734 24,238 25,492 28,978 27,868 28,620 29,455 36,785 40,562 39,778 39,007 47,682 9,678 14,645 18,696 21,277 28,498 31,646 46,087 39,703 51,824 55,854 56,438 62,439 40,066 43,866 47,491 49,236 61,772 60,853 53,756 55,506 63,195 59,741 59,897 62,518 76,478 82,749 91,679 99,491 118,138 121,119 129,298 131,994 155,581 155,373 155,342 172,639 7 8 9 10 11 12 200,000 180,000 Australia New Zealand China * Total 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 0 0 2 4 6 8 10 12 FIGURE 2.22 Plot of lamb shank demand at Tony's Lamb House. A market study shows that the demand is likely to keep increasing for another 3 years and then stabilize. The current warehouse capac- ity will not be sufficient for storage in the future. Therefore, Tony's Lamb House decides to build its own warehouse. The capacity of the warehouse should be 110% of the forecasted demand. How big a ware- house should Tony's Lamb House build? When should the warehouse be completed by? Case Study 2.4.4 Tony's Lamb Holuse is a distributor of gourmet lamb shanks. It imports lamb shanks at the beginning of every quarter from Australia, New Zealand, and China. It currently rents a warehouse with a capac- ity to store 200,000 lb of lamb shanks. The demand for lamb shanks has increased steadily over the past 3 years, as shown in Table 2.12. TABLE 2.12 Demand of Lamb Shank (in lb) at Tony's Lamb House New Zealand Quarter Australia China Total 1 2 3 4 5 6 26,734 24,238 25,492 28,978 27,868 28,620 29,455 36,785 40,562 39,778 39,007 47,682 9,678 14,645 18,696 21,277 28,498 31,646 46,087 39,703 51,824 55,854 56,438 62,439 40,066 43,866 47,491 49,236 61,772 60,853 53,756 55,506 63,195 59,741 59,897 62,518 76,478 82,749 91,679 99,491 118,138 121,119 129,298 131,994 155,581 155,373 155,342 172,639 7 8 9 10 11 12 200,000 180,000 Australia New Zealand China * Total 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 0 0 2 4 6 8 10 12 FIGURE 2.22 Plot of lamb shank demand at Tony's Lamb House. A market study shows that the demand is likely to keep increasing for another 3 years and then stabilize. The current warehouse capac- ity will not be sufficient for storage in the future. Therefore, Tony's Lamb House decides to build its own warehouse. The capacity of the warehouse should be 110% of the forecasted demand. How big a ware- house should Tony's Lamb House build? When should the warehouse be completed by