Question: Create an excel spreadsheet with a profit model to answer the following questions. Highlight the answers to each part of the question in your model.

Create an excel spreadsheet with a profit model to answer the following questions. Highlight the answers to each part of the question in your model. (5 points each total 15 points) A computer rework center has the capacity to rework 300 computers per day. The center is paid $28 for each computer reworked. The fixed cost of renting the reworking equipment is $255 per day. Work space rents for $145 per day. The cost of material is $19 per computer and labor costs $3 per computer.

a. What will be the total revenue, total cost, and profit when the center is at capacity?

b. What is the break-even number of computers reworked per day?

c. If the center has a known order to rework 250 computers on a given day, what would be the break even price for that day?

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!

4. 20 points. Create an excel spreadsheet with a profit model to answer the following questions. You are expected to use what-if-analysis and goal seek to answer your questions. A student at OSU...

Question 2 [8] Most people, when buying a house of their own, have to take out a home loan to cover the cost of buying the house. Create a spreadsheet model that calculates the monthly payment that...

After developing the spreadsheet, Use the Seal Point Surfwear Spreadsheet Model to Answer the following questions: 1. What MOQ would produce the same total relevant costs for the two alternatives?...

4 Go to the Excel spreadsheet versions of Table 6.2 to answer the following questions. (Do not round intermediate calculations. Enter your answers in thousands rounded to the nearest whole number.)...

iv. V. Instructions: 1. You need to follow the following steps for ALL questions: i Identify the objective of the firm manager as specified in the problem. Identify the decision variables in the...

The Iowa Wolves are scheduled to play against the Maine Red Claws in an upcoming game in the National Basketball Assoclation (NBA) G League. Because a player in the NBA G League is still developing...

B C D E F H M Answers 3 Points 0.5 5 0.5 2 6 0.75 3 T 0.75 4 1 5 3 EvTel wants to expand its business abroad to capture more of the market. Milos, the Vice-President of Kitchen Appliances at EvTel,...

Use cells B2 and B3 to calculate Lambda and Mu. (Example: = 7/45) Lambda - Arrival Rate (Calls per Minute) Mu - Service Rate(Calls per Minute) 1 2 3 Y Y Servers % Time Server Busy (rho) Probability...

MBA 6300 online Homework Assignment #4 Forecasting Models Instructions: After the student calculates the answers to this homework he/she must submit the answers by placing them in the Assignment # _...

If the cost of a copyright is 11,400 and has a residual value of 2800 and its useful life is 4 years. How would you calculate amortization for the first year.

Below is a partial listing of the adjusted account balances of Pina Colada at year-end on December 31, 2014: Accounts receivable $26,880 Cost of goods sold 286,720 Selling expenses (includes...

On January 1, Unity Innovations acquired 90% of Horizon Global Tech's stock for $95,000. On that date, the fair value of Horizon's assets and liabilities equaled their respective book values, with...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...