Question: PLEASE COMPLETE WORK IN EXCEL SPREADSHEET ONLY. SHOW ALL FORMULAS/FUNCTIONS TO SHOW ANSWERS (SCREENSHOTS) AND EXPLAIN TO ME HOW YOU GOT THE ANSWER. All WORK

PLEASE COMPLETE WORK IN EXCEL SPREADSHEET ONLY. SHOW ALL FORMULAS/FUNCTIONS TO SHOW ANSWERS (SCREENSHOTS) AND EXPLAIN TO ME HOW YOU GOT THE ANSWER. All WORK SHOULD BE IN EXCEL. SCREENSHOT A PICTURE OF ANSWERS THEN A SCREENSHOT OF FORMULAS IN EXCEL

Borges Machine Shop, Inc., has a 1-year contract for the production of 200,000 gear housings for a new off-road vehicle. Owner Luis Borges hopes the contract will be extended and the volume increased next year. Borges has developed costs for three alternatives. They are general-purpose-equipment (GPE), flexible manufacturing system (FMS), and expensive, but efficient, dedicated machine (DM). The cost data follow:

	General Purpose Equipment (GPE)	Flexible Manufacturing System	Dedicated Machine
Annual Contacted Units	200,000	200,000	200,000
Annual Fixed Cost	$ 100,000	$ 200,000	$ 500,000
Per Unit Variable Cost	$ 15	$ 14	$ 13

1) Which process is best for this contract? Explain

2) What is the economical volume for each process (at what volume is each process the cheapest alternative?)

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!

Please explain how you got the Bank Reconcile. Thank you Bank Reconciliation Wells Fargo Bank Balance "Hit the Slopes" Ending Cash Balance Ending Cash Balance Deposits in Transit Adjustments or...

Hello can you please help me create Bank reconciliation statements for these accounts. need a response as soon as possible, let me know of you need more information. thank you :) Transactions Date...

NEED HELP ASAP Can you please help me do a bank reconciliacion statement, if possible provide your work to see the reconciled balance. thanks Template: Western Bank Page 1 PO Box 12345 El Paso, Texas...

Week 5 Assignment - Case Study: Statistical Forecasting Dr. Megan Zobb, a key researcher within the North Luna University Medical Center, has been studying a new variant of a skin disease virus that...

Please see the attached excel spreadsheet-- this is for managerial accounting-- deals with depreciation and I am completely lost. Each tab needs to be completed and all work must be shown. Any help...

(c) In an effort to improve efficiency, Bonita University has changed their admissions procedures. Instead of adding all of the materials at the beginning of the process, they have decided to add...

The excel homework assignment below has five tabs that cover five different topics: Net Present Value Analysis, Capital Budgeting and Cost of Capital, Working Capital, Management, Financial Ratio...

Case AAA Health, Inc. ( NYSE: A 3 H ) is evaluating a new product, a vitamin C / fish oil blended energy drink. As an assistant director of the capital budgeting division of AAA Health, you are...

AAA Health, Inc. ( NYSE: A 3 H ) is evaluating a new product, a vitamin C / fish oil blended energy drink. As an assistant director of the capital budgeting division of AAA Health, you are...

Purpose Learn to build a basic business case by using data analysis techniques and interpreting and presenting their results. Techniques include weighted values, NPV calculation and comparison,...

Use the following information from the Adjustments columns of a 10-column work sheet. Number 109 124 128 Account Title Interest receivable. Office supplies Prepaid insurance 164 Accumulated...

Which of the two statements below are correct? You can only mark two alternatives and you will get 2 point for each correct answer. Which two of the following five statements are correct? All...

Unit price Unit variable cost Fixed costs Depreciation $ 4 2 0 $ 2 2 6 $ 6 5 0 , 0 0 0 $ 2 5 0 , 0 0 0 The tax rate is 2 1 percent. Consider taxes. What is the DOL at the accounting break - even...

Hugo decides to buy his Christmas gifts on Black Friday. To simplify his life, he is giving his 10 closest friends scarves for Christmas and everyone else Christmas cards. Hugo is willing to pay up...