Turcking Firm: Costs and Revenue Operation Specifics: How many loaded miles did you run last year? Total Miles last year Average MPG Average price per gallon Gallons of Tractor fuel purchased in last year? Revenue (Yearly): Gross earnings from truck(s) Total Revenue Last Year Operation Fixed Costs (Yearly): Yearly Truck payment Truck Insurance (physical, bobtail, cargo, etc.) Primary Medical insurance premiums Licenses, Registrations, and Permits (annual vehicle inspection, IRP, UCR, HUVT 22 Electronic Logging Device Phone & Internet Total Fixed Costs Last Year Operation Variable Costs (Yearly): Tractor Fuel Permits, Tolls & Taxes (IFTA, KYU, OR or NM State Permit, Tolls, Scale) Maintenance & Supplies (tires, repairs, washes, fuel additives, small tools, etc.) Travel Expense (Hotel/Lodging, paid parking, shower, etc.) Taxes (Property, etc.) Total Variable Costs Last Year Per Mile Figures 100,000 100,000 6 $3.75 16,667 $200,000.00 $200,000.00 $30,131 $7,500.00 $2,640.00 $1,800.00 $1,190.00 $2,000.00 $45,261.00 Assume all variable costs, like fuel, are incurred per mile $62,500.00 $0.63 $2,500.00 $0.03 $21,000.00 $0.21 $1,000.00 $0.01 $4,000.00 $0.04 $91,000.00 $0.91 $2.00 $2.00

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter7: Allocating Costs Of Support Departments And Joint Products
Section: Chapter Questions
Problem 1CE: The expected costs for the Maintenance Department of Stazler, Inc., for the coming year include:...
icon
Related questions
Question

How do I find accounting profit, producer surplus, variable cost for this spreadsheet?

Turcking Firm: Costs and Revenue
Operation Specifics:
How many loaded miles did you run last year?
Total Miles last year
Average MPG
Average price per gallon
Gallons of Tractor fuel purchased in last year?
Revenue (Yearly):
Gross earnings from truck(s)
Total Revenue Last Year
Operation Fixed Costs (Yearly):
Yearly Truck payment
Truck Insurance (physical, bobtail, cargo, etc.)
Primary Medical insurance premiums
Licenses, Registrations, and Permits (annual vehicle inspection, IRP, UCR, HUVT 22:
Electronic Logging Device
Phone & Internet
Total Fixed Costs Last Year
Operation Variable Costs (Yearly):
Tractor Fuel
Permits, Tolls & Taxes (IFTA, KYU, OR or NM State Permit, Tolls, Scale)
Maintenance & Supplies (tires, repairs, washes, fuel additives, small tools, etc.)
Travel Expense (Hotel/Lodging, paid parking, shower, etc.)
Taxes (Property, etc.)
Total Variable Costs Last Year
Per Mile Figures
$2.00
$2.00
100,000
100,000
6
$3.75
16,667
$200,000.00
$200,000.00
$30,131
$7,500.00
$2,640.00
$1,800.00
$1,190.00
$2,000.00
$45,261.00
Assume all variable costs, like fuel, are incurred per mile
$62,500.00
$0.63
$2,500.00
$0.03
$21,000.00
$0.21
$1,000.00
$0.01
$4,000.00
$0.04
$91,000.00
$0.91
Transcribed Image Text:Turcking Firm: Costs and Revenue Operation Specifics: How many loaded miles did you run last year? Total Miles last year Average MPG Average price per gallon Gallons of Tractor fuel purchased in last year? Revenue (Yearly): Gross earnings from truck(s) Total Revenue Last Year Operation Fixed Costs (Yearly): Yearly Truck payment Truck Insurance (physical, bobtail, cargo, etc.) Primary Medical insurance premiums Licenses, Registrations, and Permits (annual vehicle inspection, IRP, UCR, HUVT 22: Electronic Logging Device Phone & Internet Total Fixed Costs Last Year Operation Variable Costs (Yearly): Tractor Fuel Permits, Tolls & Taxes (IFTA, KYU, OR or NM State Permit, Tolls, Scale) Maintenance & Supplies (tires, repairs, washes, fuel additives, small tools, etc.) Travel Expense (Hotel/Lodging, paid parking, shower, etc.) Taxes (Property, etc.) Total Variable Costs Last Year Per Mile Figures $2.00 $2.00 100,000 100,000 6 $3.75 16,667 $200,000.00 $200,000.00 $30,131 $7,500.00 $2,640.00 $1,800.00 $1,190.00 $2,000.00 $45,261.00 Assume all variable costs, like fuel, are incurred per mile $62,500.00 $0.63 $2,500.00 $0.03 $21,000.00 $0.21 $1,000.00 $0.01 $4,000.00 $0.04 $91,000.00 $0.91
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Discontinuing operations for a product or a service line
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning