Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Chipper Payroll Services knows the demand for its services during the current year is around 50,000 worker-hours and with current operations covers all customer demand

Chipper Payroll Services knows the demand for its services during the current year is around 50,000 worker-hours and with current operations covers all customer demand (i.e., Chippers capacity currently is 50,000 worker-hours). Chipper is planning on a 5% growth rate each year. Chippers current office space and staff will eventually outgrow demand. Expanding the office space and staff depends mostly on the hours that will be worked total in the facility. If we let x=total worker-hours, Chipper will incur a one- time cost of $15x to expand [i.e., if Chipper goes from 50,000 worker-hour capacity to 70,000 worker-hour capacity, it will incur a cost of $15x(70,000-50,000) = $300,000]. Chipper needs to expand its current space and staff, since any new business will be lost to its competitors if it cannot accommodate the new customers. Each customer serviced incurs a variable cost of $3.00 per worker-hour. It also costs Chipper $6.00 per worker-hour of capacity per year (i.e., if Chipper has 70,000 worker hours total then Chipper incurs $6x70,000 = $420,000 per year in costs). Chipper garners $25 per worker hour from its customers. Construct an Excel spreadsheet model to determine what the projected revenue, costs, and potential profits would be over the next 10 years based on the current capacity, 50,000 worker-hours, an expansion to 70,000 worker-hours, and an expansion to 90,000 worker hours.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Statement Fraud Prevention And Detection

Authors: Zabihollah Rezaee

1st Edition

0471092169, 978-0471092162

More Books

Students also viewed these Finance questions