Colorado State University M5 Global Budgeting for a Non Manufacturer Paper
Option #1: Budgeting for a Non-ManufacturerYour client, Bugs R Gone, has requested assistance with preparation of their budget for the upcoming year while they have a part time accounting helper out on leave. The company provides pest control services to homes. There is a small office the company operates out of with a few company-owned vehicles that the pest control technicians use when they are out in the field. Other than the pesticides, sprayers, gloves, and other tools used by the technicians, the company has very little in the way of inventory/supplies.The owner, Jack Sutton, estimates there will be approximately 5,500 jobs during the year. Each job takes approximately 2.5 hours to complete, including the technician’s travel time going from one job to another. Technicians are paid $18 an hour. The company outsources the majority of its accounting work to you, but it has a part-time retired accountant helping out with some of the basics.Overhead is allocated on the basis of direct labor hours. Variable overhead costs include materials and supplies at $4.50 per direct labor hour. Fixed overhead costs include depreciation on equipment and vehicles of $25,000 and miscellaneous other job-related expenses of $10,000. There is also indirect labor of $6,500.Using the data above, Jack has requested you to complete the following budgets/schedules/calculations for him:Direct labor budget in hours and dollars;Budgeted overhead allocation rate based on budgeted quantity of cost drivers;Budgeted cost of all jobs for the year and budgeted cost of an average job;Revenues budget assuming each house treatment costs $100, and the instance of no charge re-treatments is 5%;Budgeted operating income; andEstimate how the business would be impacted if the company lost business and the jobs were actually 5,300 instead of 5,500.Submit your responses in an Excel spreadsheet, neatly organized, with written summaries as needed. Your paper must be formatted according to CSU-Global Guide to Writing and APA Requirements (Links to an external site.). Reference Lynda.com in the CSU-Global Library (Links to an external site.) for Microsoft Excel tutorials or use the Excel Tutorials link found in the classroom if assistance is needed.Review the Module 5 Critical Thinking Rubric for full details on how you will be graded on this assignment.

Student Review

The paper is high quality, 0% plagiarism and the flow is just great. Thank you so much. I will always work with you. Highly recommended.

This question was posted privately, you cannot see the answer/s provided by the tutor. You can post a similar question for high quality help.

Find the best tutors/writers

Only here on Study Help 24/7

Why Studyhelp247 is the best homework help website

We often see students asking why Studyhelp247 is the best homework help website and why many students use our services. Here is why:

  • Our tutors are professionals in their respective subjects. This ensures that they submit high quality work to all our students.
  • We have a strict anti-plagiarism policy, ensuring that students receive high quality and original work.
  • Our pricing is the most student-friendly. Students pay 0% service fees, making it possible to receive help for as low as $5 per page.
  • Our website is secure and privacy is our number on priority. Any question posted on studyhelp247 cannot be seen anywhere else.
  • We have the most responsive customer support agents.
  • We offer homework help services in all English-Speaking countries, making us a global homework help site.

We have helped over 5,000 students in close to 40 countries worldwide. Join the movement.

Find Tutors

They're always here to help

Or

Post New Question

1000+ tutors are waiting to help

Or