1. The monthly fixed cost is FC= The monthly total cost is TCx=

The monthly total revenue is TRx= where x is the number of sensors produced over a month.

3. The break-even analysis graph is:
4. [Provide the break-even volume and revenue and explain how these are shown on the graph.]
5. [Provide the net income per month and explain how this is found on the graph.]

With full production capacity and a selling price of $80, the break-even analysis graph is:

A=4 B=6 C=9 D=0

1) PROBLEM 1: BREAK EVEN ANALYSIS You are the newly appointed manager of WinTech, a small local manufacturer of single board computers (SBC) that uses a wholesaler for distribution. a) On the "Problem 1" worksheet of the Excel workbook, enter formulas for costs and revenues into your Excel worksheet to create a table of values. See the end of this document, what your completed work should look like for problem 1. b) In your excel spreadsheet (worksheet problem one) determine functions TC(x) for total cost and TR(x) for total revenue, where x is the number of sensors produced over a month, and NTR(x) for total revenue at the new sale price using the designated values from your student number. In your data sheet choose the minimum value of x to be 0 and increment by 10 up to the full capacity. Formulas are as follows: During the first few days on the job, you create fin your excel spreadsheet on the problem one worksheet tab) the following data about the company: Total capacity formula (substituting the variables using the appropriate digits from your student number): WinTech has the capacity to produce in quantities: 10(70+A) SBCs per month. This is the end point for your data. Your total costs should not exceed this capacity for the value of "X". This is operating at total maximum capacity. Current production rate (substituting the variables using the appropriate digits from your student number): : Current production rate in quantity: (500 + 10B) SBCs per month. This is an operating level that is less than maximum capacity. A B E TI G D NTR(x) X TC(x) TR(x) 1 TC(x) = total cost TR(x)=total revenue NTR(x)=total revenue at new sale 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160 1) PROBLEM 1: BREAK EVEN ANALYSIS You are the newly appointed manager of WinTech, a small local manufacturer of single board computers (SBC) that uses a wholesaler for distribution. a) On the "Problem 1" worksheet of the Excel workbook, enter formulas for costs and revenues into your Excel worksheet to create a table of values. See the end of this document, what your completed work should look like for problem 1. b) In your excel spreadsheet (worksheet problem one) determine functions TC(x) for total cost and TR(x) for total revenue, where x is the number of sensors produced over a month, and NTR(x) for total revenue at the new sale price using the designated values from your student number. In your data sheet choose the minimum value of x to be 0 and increment by 10 up to the full capacity. Formulas are as follows: During the first few days on the job, you create fin your excel spreadsheet on the problem one worksheet tab) the following data about the company: Total capacity formula (substituting the variables using the appropriate digits from your student number): WinTech has the capacity to produce in quantities: 10(70+A) SBCs per month. This is the end point for your data. Your total costs should not exceed this capacity for the value of "X". This is operating at total maximum capacity. Current production rate (substituting the variables using the appropriate digits from your student number): : Current production rate in quantity: (500 + 10B) SBCs per month. This is an operating level that is less than maximum capacity. A B E TI G D NTR(x) X TC(x) TR(x) 1 TC(x) = total cost TR(x)=total revenue NTR(x)=total revenue at new sale 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160