50.1K

Verified Solution

Link Copied!

Juanita rents ATVs to tourists, and her business is located just outside a tourist area in Minnesota. Tourists rent for either a half-day, or a full day. Consider information items 1-4 below, and then the information in the table: 1. Juanita's ATV fleet has 25 vehicles total, and this was constant throughout the year. 2. Juanita operates 52 weeks/year, 12 months/year. 3. In the table below, some variable costs are per week and some are per rental; fixed costs are per month 4. During a typical week Juanita has a total of 100 rental transactions. 70 of these rentals are for half day periods, and the remaining 30 rentals are for a full day. B 100 160 30 25 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Price Juanita charges per rental ($) half-day full-day Variable cost per ATV per week ($) maintenance fee paid to county Variable cost per ATV per rental ($) half-day full-day Fixed costs per month (S) insurance property costs advertising misc 10 15 14,000 6,000 3,500 21,000 Provide an Excel formula that would compute Juanita's profit for a year. The formula will have several parts, so put some words under each part to indicate what you are doing. For example, write "fixed" under the part of the formula that refers to fixed costs. Every portion of your formula must be clearly labeled, and this determines how partial credit is assigned. Also, where possible, reference cells. So do not enter numbers if a cell reference can be made (reference the cells)

Answer & Explanation Solved by verified expert

See Answer