Question: Open the file Nowlin Plastics. Recall that we have modeled total profit for the product CD-50 in this spreadsheet. Suppose we have a second product

Open the file Nowlin Plastics. Recall that we have modeled total profit for the product CD-50 in this spreadsheet. Suppose we have a second product called a CD-100, with the following characteristics:

Fixed Cost = $2500

Variable Cost per Unit = $1.67

Selling Price per Unit = $4.40

Extend the model so that the profit is calculated for each product and then totaled to give an overall profit generated for the two products. Use a CD-100 production volume of 1200. Save this file as Nowlin Plastics2.xls. Place the data for CD-100 in column C and copy the formulas in rows 14, 16, and 18 to column C.

Step by Step Solution

★★★★★

3.40 Rating (175 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 Nowlin Plastics 2 3 4 5 6 7 Fixed Cost Variable Cost Per U... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

148-M-S-Q-M (158).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

Recall that we have two write policies and write allocation policies, and their combinations can be implemented either in L1 or L2 cache. Assume the following choices for L1 and L2 caches: L1...

The market price of a semi-annual pay bond is $987.44. It has 10.00 years to maturity and a coupon rate of 7.00%. Par value is $1,000. What is the effective annual yield? A firm just paid a dividend...

Two workers use blocks and tackles attached to the bottom of an I-beam to lift a large cylindrical tank. Knowing that the tension in rope CD is 61 lb, replace the force exerted at C by rope CD with...

Open the file Nowlin Plastics. Recall that we have modeled total profit for the product CD-50 in this spreadsheet. Modify the spreadsheet to take into account production capacity and forecasted...

Prepare the financial analysis to support your decision between bankruptcy,voluntary reorganization,and Chapter11reorganization.It must be complete and prepared in a professional level,with the...

1)Widget Manufacturing has just completed a major change in its quality control (QC) process. Previously, QC inspectors had reviewed products at the end of each major process, and the company's 10 QC...

Chapter 4Exercises 5, 8, 12, 17, and18 Problem 12 172 iStockphoto Variable Costing In 2012, the all-tube amplifier p r o d u ce d b y C l a u s e n Tu b e r e ce i ve d rave reviews and the company...

(1) Income Statement Referencing this week?s readings and lecture, address the following: ? What are the two causes of an increasing or decreasing sales number? ? Discuss all the reasons that might...

Below is the assignment, attached in the excel file is actually all the answers, I need these transferred into my own excel file, answering all the questions below. Integrated mini-case: ?Working...

Baxter Pauline established Summit Services, P.C., a professional corporation, on December 1 of the current year. Summit Services offers financial planning advice to its clients. The effect of each...

Summary information from the financial statements of two companies competing in the same industry follows. Required 1. For both companies compute the (a) Current ratio, (b) Acid-test ratio, (c)...

To maintain or enhance organizational performance, healthcare organizations rely on human resources for what important functions?

You hold a long position in an option portfolio. It contains an European call option on stock XYZ with a strike price of $40 and a put option on the same stock with a strike price of $30. The call...

Ballooning Out of Control LLC (BLOC or the Company) is a manufacturer of hot air balloons. Due to decreased demand for hot air balloons and challenging industry conditions, BLOCs management is...

Sunset Boards currently pays out 40 percent of net income as dividends to Tad and the other original investors, and it has a 21 percent tax rate. You are Christina's assistant, and she has asked you...

Hasan Fareed, a 24-year-old college graduate, never took a personal finance class. He pays his bills on time, has managed to save a little in an investment account, and with the help of an...

If your cable television goes out, you phone the cable company to get it fixed. Does a real person answer your call? These days, probably not. It is far more likely that you will get an automated...

Earnings and more A second predictor in Exercise 13 improved the regression model of Exercise 1, so lets try a third. Heres a model with average ACT score of the entering class included: Response...

Assume that in an empty Excel worksheet in cell A1 you enter the formula = B1*$F$3. You now copy this formula into cell E6. What is the modified formula that appears in E6?

Resolve Problem 14- 12 (Goodeating Dog Chow) for five periods. In Problem 14- 12, Goodeating Dog Chow Company produces a variety of brands of dog chow. One of their best values is the 50-pound bag of...

Changes in the Cash Account (Please use the appropriate letter for each of the numbered items below. Use ; I for increase, D for decrease or N for no change). Please type the number and the...

Peter Piper has applied for a mortgage of $ 1 4 0 , 0 0 0 . Interest is computed at 7 . 5 percent compounded semiannually. The mortg vill be paid off over 2 0 years. ( For all requirements, use a...

Suppose your grandmother deposited $3800 into an account on your 3rd birthday. If the account earns 8% interest compounded quarterly, find the account balance on your 18th birthday. Round your answer...