Question

In: Economics

Answer In EXCEL Best Plastics produces a line of cell phone covers. Its best-selling cover is...

Answer In EXCEL

Best Plastics produces a line of cell phone covers. Its best-selling cover is the Cobra model, a
slim but very durable black plastic cover. The annual fixed cost for the Cobra model is $234,000.
This fixed cost includes management time, advertising, and other costs. In addition, the variable
cost, including labor and material costs, is $2 for each unit produced. Best Plastics sells the
Cobra for $3.50 per unit. The exact demand for next year is not known. Best Plastics wants to
analyze the possible profit against different quantities.
Define “q” as the quantity (number of units) required next year. Define TC(q) as the total cost to
manufacture q units. Define TR(q) as the total revenue from selling q units.
a. Write the algebraic equations for TC(q) and TR(q).

b. Define TP(q) as the total profit from selling q units, that is, TR(q) – TC(q). Write the
algebraic equation for TP(q).

Solutions

Expert Solution

We have the following information

Fixed Cost = $234,000

Variable cost per unit = $2

Total Cost equation: TC(q) = 234,000 + 2q, where q is the number of units produced

Total Revenue equation: TR(q) = Price × Quantity

TR(q) = 3.50q

Total Profit: TP(q) = TR(q) – TC(q)

TP(q) = 3.50q – 234,000 – 2q

TP(q) = 1.50q – 234,000

Quantity

Fixed Cost ($)

Variable Cost ($2 per unit)

Total Cost ($)

Price per unit ($)

Marginal Cost ($)

0

234000

0

234000

3.5

--

1

234000

2

234002

3.5

2

2

234000

4

234004

3.5

2

3

234000

6

234006

3.5

2

4

234000

8

234008

3.5

2

5

234000

10

234010

3.5

2

6

234000

12

234012

3.5

2

7

234000

14

234014

3.5

2

8

234000

16

234016

3.5

2

9

234000

18

234018

3.5

2

10

234000

20

234020

3.5

2

11

234000

22

234022

3.5

2

12

234000

24

234024

3.5

2

13

234000

26

234026

3.5

2

14

234000

28

234028

3.5

2

15

234000

30

234030

3.5

2

16

234000

32

234032

3.5

2

17

234000

34

234034

3.5

2

18

234000

36

234036

3.5

2

19

234000

38

234038

3.5

2

20

234000

40

234040

3.5

2


Related Solutions

Stew's Plastics produces a variety of CD cases. The best-selling product is the CD-50. Several products...
Stew's Plastics produces a variety of CD cases. The best-selling product is the CD-50. Several products are produced on the same manufacturing line, so there is a setup cost each time a changeover is made for a new product. The setup cost for the CD-50 is $3200. In addition, it costs $1.82 for each unit (CD Case) produced, and for each 100 CD Cases they have to put them in a box that costs $2.50. If there is less than...
The Phone Company has the following costs of producing and selling a cell phone when it...
The Phone Company has the following costs of producing and selling a cell phone when it produces and sells 100,000 cell phones per month: Per unit manufacturing cost             Direct materials                                              $60.00             Direct labor                                                     10.00             Variable manufacturing overhead cost             35.00             Fixed manufacturing overhead cost                 20.00 Per unit selling cost             Variable                                                          20.00             Fixed                                                               10.00 Note that ‘100,000’ is the denominator used to calculate fixed costs per unit. Total fixed costs...
A company that produces cell phones claims its standard phone battery lasts longer on average than...
A company that produces cell phones claims its standard phone battery lasts longer on average than other batteries in the market. To support this claim, the company publishes an ad reporting the results of a recent experiment showing that under normal usage,their batteries last at least 35 hours. To investigate this claim, a consumer advocacy group asked the company for the raw data. The company sends the group the following results: 35, 34, 32, 31, 34, 34, 32, 33, 35,...
Using the data in the Excel file Cell Phone Survey, determine if the mean response for...
Using the data in the Excel file Cell Phone Survey, determine if the mean response for Customer Service rating is different for the carriers (consider only AT&T, Verizon, and Sprint) for significance level of 5%. Gender   Carrier   Type   Usage   Signal strength   Value for the Dollar   Customer Service M   AT&T   Smart   High   5   4   4 M   AT&T   Smart   High   5   4   2 M   AT&T   Smart   Average   4   4   4 M   AT&T   Smart   Very high   2   3   3 M   AT&T   Smart   Very...
Hello, Just want to compare. Thanks, i-Covers Company manufactures designer cases for cell phones. Each cover...
Hello, Just want to compare. Thanks, i-Covers Company manufactures designer cases for cell phones. Each cover sells for $20.00. The cost currently assigned to each decal is $12.00. A competitor is introducing a new designer line of cases that will sell for $16.00 each. Management of i-Covers believes it must lower its selling price to $16.00 in order to compete in this highly cost-conscious market. Marketing believes that the new selling price will allow i-Covers to maintain the current sales...
To automatically insert electronic components in printed circuit boards for a cell phone production line, a...
To automatically insert electronic components in printed circuit boards for a cell phone production line, a $500,000 surface mount placement (SMP) machine is being evaluated by a manufacturing engineer at Motorolla. Over the 10-year planning horizon, it is estimated the SMP machine will produce annual cost savings of $92,500. The engineer estimates the machine will be worth $50,000 at the end of the 10-year period. Based on the firm’s 10% MARR, how long does it take for the new SMP...
McElroy, Inc., produces a single model of a popular cell phone in large quantities. A single...
McElroy, Inc., produces a single model of a popular cell phone in large quantities. A single cell phone moves through two departments, assembly and testing. The manufacturing costs in the assembly department during March follow: Direct materials $ 140,400 Conversion costs 117,500 $ 257,900 The assembly department has no beginning Work-in-Process Inventory. During the month, it started 26,000 cell phones, but only 21,000 were fully completed and transferred to the testing department. All parts had been made and placed in...
McElroy, Inc., produces a single model of a popular cell phone in large quantities. A single...
McElroy, Inc., produces a single model of a popular cell phone in large quantities. A single cell phone moves through two departments, assembly and testing. The manufacturing costs in the assembly department during March follow: Direct materials $ 148,800 Conversion costs 114,400 $ 263,200 The assembly department has no beginning Work-in-Process Inventory. During the month, it started 24,000 cell phones, but only 20,000 were fully completed and transferred to the testing department. All parts had been made and placed in...
Comptel International is a manufacturer of the MX7500 cell phone. The following are its sales in...
Comptel International is a manufacturer of the MX7500 cell phone. The following are its sales in units for the first quarter and its anticipated sales in units for the coming quarter. The distributor price is $300 per unit .Units September (actual) 90,000 October (actual )   90,000 November (actual) 100,000 December (actual ) 98,000 January   100,000 February     90,000 March     110,000 April       125,000 May      150,000 June     165,000 July    155,000 August    140,000 Comptel likes to keep 10% of the following month’s...
Can someone show me how to do this on excel? Question involves cell phone users. Mean...
Can someone show me how to do this on excel? Question involves cell phone users. Mean monthly data usage = 5.8 GB/month StDev monthly data usage = 2.5 GB/month "Heavy users" are those that use >= 9 GB/month a.) What is the probability a "heavy user" uses more than 10 GB/month? b.) Two users are selected at random. What is the probability at least one of them is a heavy user? c.) Five users are selected at random. What is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT