Account Analysis Method Penny Hassan runs the Shear Beauty Salon near a college campus. Several months ago, Penny used some unused space at the back of the salon and bought two used tanning beds. She hired a receptionist and kept the salon open for extended hours each week so that tanning clients would be able to use the benefits of their tanning packages. After three months, Penny wanted additional information on the costs of the tanning area. She accumulated the following data on four accounts: Wages Supplies and Maintenance Equipment Depreciation Electricity Tanning Minutes Number of Visits January $1,765 $1,467 $165 $362 4,098 432 February 1,731 1,878 165 420 3,975 372 March 1,812 4,044 165 672 6,831 570 Penny decided that wages and equipment depreciation were fixed. She thought supplies and maintenance would vary with the number of tanning visits and that electricity would vary with the number of tanning minutes. Required: 1. Calculate the average account balance for each account. Calculate the average monthly amount for each of the two drivers. (Round all answers to the nearest dollar or the nearest whole unit.) Use your rounded answers in all subsequent computations. Average Account Balance Wages $fill in the blank 1 Supplies & Maintenance $fill in the blank 2 Equipment Depreciation $fill in the blank 3 Electricity $fill in the blank 4 Tanning Minutes fill in the blank 5 Number of Visits fill in the blank 6 2. Calculate fixed monthly cost and the variable rates for the account averages. Round your answers to the nearest cent and use your rounded answers in all subsequent computations. Variable rate for supplies & maintenance $fill in the blank 7 per visit Variable rate for electricity $fill in the blank 8 per minute Fixed cost per month $fill in the blank 9 Express the results in the form of an equation for total cost. (Round to the nearest cent.) Cost = $fill in the blank 10 + $fill in the blank 11 (visit) + $fill in the blank 12 (minute) 3. In April, Penny predicts there will be 372 visits for a total of 3,810 minutes. What is the total cost for April? If required, round your answer to the nearest dollar. $fill in the blank 13 4. Suppose that Penny decides to buy a new tanning bed at the beginning of April for $8,832. The tanning bed is expected to last four years and will have no salvage value at the end of that time. What will be the new equation for total cost? If required, round your answers to the nearest cent. Cost = $fill in the blank 14 + $fill in the blank 15 (visit) + $fill in the blank 16 (minute) What is the new expected cost in April based on the prediction provided in Requirement 3 (above)? When required, round your answer to the nearest dollar. $fill in the blank 17