Charlie Stork rented a truck for his business on two previous occasions. Since he will soon be
Question:
Charlie Stork rented a truck for his business on two previous occasions. Since he will soon be renting a truck again, he would like to analyze his bills and determine how the rental fee is calculated. His two bills for truck rental show that on September 1, he drove 1,000 miles and the bill was $1,500, and on December 5, he drove 600 miles and the bill was $1,380.
Required
Construct a spreadsheet to calculate the variable and fixed costs of this mixed cost that will allow Mr. Stork to predict his cost if he drives the truck 700 miles. The cells that show as numbers should all be formulas except C5, C6, E5, E6, and C18. Constructing the spreadsheet in this manner will allow you to change numbers in these five cells to recalculate variable cost, fixed cost, or predicted total cost.
.:.
Spreadsheet Tip
1. To format cells to show dollar signs, commas, or both, choose Format, then Cells, then click on the tab titled Numbers, and choose Accounting.
Step by Step Answer:
Fundamental Managerial Accounting Concepts
ISBN: 978-0078110894
6th Edition
Authors: Edmonds, Tsay, olds