Question

PLEASE HELP ! It's two questions so you can charge me twice. Will vote thumbs up for a right question

X E201 Assgn6_p1_cost_calculations_blank.xls Open with Google Sheetsv Variable Cost Average Total Cost Marginal Cost Variable Cost Total Fixed Cost $15.00 $15.00 $15.00 Quanti Total Cost $0.00 $15.00 10.67 $12.67 $16.00 $20.67 $26.67 $34.00 $42.67 $52.67 $64.00 $76.67 $90.67 $106.00 $122.67 $140.67 S160.00 $180.67 $202.67 S226.00 $250.67 4 12 13 14 15 16 17 18 19 12 14 20 Assignment 6 Part I Case Description te a machine sshop.There axe simila Bob and Anna are your shops in your area hence it's a highly competitive business. You recently observed that potential clients don't care about repair quality and instead seek the lowest prices for the repair job. Recently Bob and Anna announced their retirement plans and offered to sell the shop for you and your family. Yous family spent $1,000 of their savings to go towards this purchase. The rental of one of the equipment used at the repair shop costs $15 per day for the next 3 years. The shop must hire labor and puschase some chemical solutions, nuts and bolts, etc. to operate the shop. The research you conducted shows that the cost for labor and supplies is as follows relatives and they operate $10.67 12.67 $16.00 $20.67 $26.67 $34.00 $42.67 $52.67 $64.00 76.67 $90.67 106.00 12267 $140.67 160.00 180.67 $202.67 $226.00 $250.67 $276.67 10 12 13 14 15 16 18 19 20 Duning the winter season, you have obsesved that you can charge a price of $14.00 per machine. During other seasons, the demand is much lower. You are only able to charge a price $4.67 per machine fix Now is the winte season and you are doing maintenance work for 17 machines per day. Your family wants your advice. #1-Use the excel sheet to calculate and complete the six column blank spaces from TVC to TFC. Use excel graphing tool to drau the graph of AVC, ATC and MC together. Due Mon Mar 25, in class. lsee baief guide on Excel below #2-Use the excel format provided to prepare a report to help your family understand what they should do now and in the off-season. Wite a brief explanation to help them undestand why they should follow your advice. Due at the end of class Mon, Mar 25. Brief Excel Guide In order to use excel to do easy math follow the followin steps The above table is an example of an excel sheet olumn C follow the If ou want to add column A and B and you want the result to appear in c following steps Inside the cell where you want the results to be (Column-C, Row-1>C1) type the"-* sign and open bracket "and type the cells to be added in ous example it would be -(A1+B1) and then close bracket ". Then press "enter"in your keyboard. If you want Excel to do the same job for the sest of the rouws instead of typing the formula again you can drag down and apply the same formula. To do that you will need to put yous mouth cursor to the lower night angle of the cell where you obtained the initial esult from the formula (C1), hold and drag the plus sign as shows to your right here. To draw a graph using excel tools follow the following steps; - 1. Select/highlight the columns and ows you want to graph n this exercise Quantity, ATC, AVC and MC. Variable Average Marginal Quantity Cost Total Cost Cost 10 67 067 13.83 5.17 8 92 $467 2. On the Insert tab, in the Charts gxoup,I d- Mon Mar 25, in class. click the Line symbol. Spakines 3. Choose the line without marks

Answer 1

(Question 1)

Working notes:

(a) TC = TVC + TFC

(b) ATC = TC/Q

(c) AVC = TVC/Q

(d) MC = Change in TC / Change in Q

The filled-in table as follows with Excel formula screenshot attached.

Q	AVC	ATC	MC	TVC	TC	TFC
0				0.00	15.00	15.00
1	10.67	25.67	25.67	10.67	25.67	15.00
2	6.34	13.84	2.00	12.67	27.67	15.00
3	5.33	10.33	29.00	16.00	31.00	15.00
4	5.17	8.92	6.67	20.67	35.67	15.00
5	5.33	8.33	35.00	26.67	41.67	15.00
6	5.67	8.17	14.00	34.00	49.00	15.00
7	6.10	8.24	43.67	42.67	57.67	15.00
8	6.58	8.46	24.00	52.67	67.67	15.00
9	7.11	8.78	55.00	64.00	79.00	15.00
10	7.67	9.17	36.67	76.67	91.67	15.00
11	8.24	9.61	69.00	90.67	105.67	15.00
12	8.83	10.08	52.00	106.00	121.00	15.00
13	9.44	10.59	85.67	122.67	137.67	15.00
14	10.05	11.12	70.00	140.67	155.67	15.00
15	10.67	11.67	105.00	160.00	175.00	15.00
16	11.29	12.23	90.67	180.67	195.67	15.00
17	11.92	12.80	127.00	202.67	217.67	15.00
18	12.56	13.39	114.00	226.00	241.00	15.00
19	13.19	13.98	151.67	250.67	265.67	15.00
20	13.83	14.58	140.00	276.67	291.67	15.00

E 685- ATC AVC MC - Microsoft Excel HomeInsertPage LayoutFormulas Data Review View novaPDF Σ AutoSum cut Copy Format Painter B Calibri General Format Sort & FilterSelect Merge Find & Formatting as Table Styles Clear Alignment Number Styles Cells Editing 1 a AVC ATC -E2+G215 E3/A3 F3/A3 F3-D2 10.67 E3+G3 15 -ES/AS -E6/A6 -ES+GS 15 20.67 E6+G6 15 26.67 E7+G7s -E8 G815 -E9/A9 -f9/A9 -F9-D8 42.67 -E9tG9 15 E10/A10 F10/A10 -F10-D9 52.67 E10+G10 15 -E11+G11 15 12 10 E12/A12 F12/A12 -F12-D11 76.67 E12+G12 15 13 11 E13/A13 F13/A13 -F13-D12 90.67 E13+G13 15 -E14 G14 15 15 13 E15/A15 F15/A15 -F15-D14 122.67 E15+G15 15 16 14 E16/A16 F16/A16 -F16-D15 140.67 E16+G16 15 -E17+G17 15 18 16 E18/A18 F18/A18 -F18-D17 180.67 E18+G18 15 19 17 E19/A19 F19/A19 -F19-D18 202.67 E19+G19 15 -E20+G20 15 21 19 E21/A21 F21/A21 F21-D20 250.67 E21+G21 15 22 20 E22/A22 F22/A22 F22-D21 276.67 E22 G22 15 -FS-D4 -F6-D5 10 8 11 9 E11/A11F11/A11 F11-D10 64 14 12 E14/A14 F14/A14 -F14-D13 106 17 15 E17/A17 F17/A17 -F17-D16 160 20 18 E20/A20 F20/A20 -F20-D19 226 14 4 ト 커 Sheet1/ Sheet2 Sheet3 EE ▲h@ 。..al ENG 14:01 US 29-03-2019

NOTE: As per Answering Policy, 1st question has been answered.