Question: PLEASE SHOW WORK IN EXCEL WITH FORMULA'S SHOWN THANKS! PLEASE SHOW WORK IN EXCEL WITH FORMULA'S SHOWN THANKS! Year 6. Hickory Manufacturing Company forecasts the

PLEASE SHOW WORK IN EXCEL WITH FORMULA'S SHOWN THANKS!

PLEASE SHOW WORK IN EXCEL WITH FORMULA'S SHOWN

Year 6. Hickory Manufacturing Company forecasts the following demand for a product (in thousands of units) over the next 5 years: 1 2 3 4 5 Forecast demand 60 79 81 84 84 Currently the manufacturer has seven machines that operate on a two-shift (eight hours each) basis. Twenty days per year are available for scheduled maintenance of equipment with no process output. Assume there are 250 workdays in a year. Each manufactured good takes 25 minutes to produce. a. What is the capacity of the factory? b. At what capacity levels (percentage of normal capacity) would the firm be operating over the next 5 years based on the forecasted demand? (Hint: Compute the ratio of demand to capacity for each year.) c. Does the firm need to buy more machines? If so, how many? When? If not, justify

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

7Project Evaluation: Tortuga Fishing Equipment Company Judson W. Russell Abstract This case study on project evaluation is applicable for beginning courses in corporate finance or finance strategy....

PLEASE SHOW WORK IN EXCEL THANK YOU! Green-Log Manufacturing Capital Budgeting Analysis In 1997 Michelle Green started Green-Log Manufacturing, a company dedicated to manufacturing environmental...

financee.. no handwritten answers You think the intrinsic value of Biogen Pharmaceuticals stock is somewhere around $300 a share. At the same time, you see they only trade at $250 a share on the...

TVM with Excel Assignment #3 Life is messy and deciding how to allocate capital resources is complicated. So, unlike the highly simplified problems used in class (and in the online examples,...

TVM with Excel Assignment # 3 Life is messy and deciding how to allocate capital resources is complicated. So , unlike the highly simplified problems used in class ( and in the online examples,...

TVM with Excel Assignment #3 Life is messy and deciding how to allocate capital resources is complicated. So, unlike the highly simplified problems used in class (and in the online examples,...

Please show work in excel. TVM with Excel Life is messy and deciding how to allocate capital resources is complicated. So, unlike the highly simplified problems used in class (and in the online...

Please show your work using EXCEL FORMULA AND FUNCTIONS. You are given all of the information provided in the attached case. Show all of your work, calculations, and explain your answers! Show your...

I need to complete this. Please show me excel formula. 2. The Three River Manufacturing Company forecasts monthly demand for its product for the next year as 418, 414, 395, 381, 372, 359, 386, 398,...

Use the Tax Rate Schedules to determine tax liability for each of the cases in problems 43, 44, and 45, above.

Beautiful America Transportation (BAT) began 2010 with accounts receivable, inventory, and prepaid expenses totaling $58,000. At the end of the year, BAT had a total of $55,000 for these current...

20. Santo SA has eight expense accounts in its general ledger which could be classified as selling expenses. Should Santo report these eight expenses separately in its income statement or simply...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...