The following table provides information on planned and actual inputs and outputs of an automotive service center in terms of standard hours of work. The beginning backlog is 14 standard hours of work. Determine the cumulative deviations and the backlog for each period. Week 1 3 4 Planned Input Actual Input 30 30 30 30 20 32 34 25 28 25 Deviation Cumulative Deviation Planned output Actual Output 30 30 30 30 25 30 28 28 30 22 Deviation Cumulative Deviation Actual Backlog 14

The following table provides information on planned and actual inputs and outputs of an automotive service center in terms of standard hours of work. The beginning backlog is 14 standard hours of work. Determine the cumulative deviations and the backlog for each period. Week 1 3 4 Planned Input Actual Input 30 30 30 30 20 32 34 25 28 25 Deviation Cumulative Deviation Planned output Actual Output 30 30 30 30 25 30 28 28 30 22 Deviation Cumulative Deviation Actual Backlog 14

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

I need help setting up excel solver. I am not clear.
What is the importance of statistics in property management work?
What assumptions does break even analysis make ?
What is a BFOQ? Why is it used in the workplace? Provide 3 examples of when it might be necessary to have a BFOQ.
A business management area where a managers need to concern business competition, creation of competitive advantage and adapting changing business environment. * operations accounting finance strategy
As the owner of a fast food restaurant with declining sales, your customers are looking for something new and exciting on the menu. Your market research indicates that they want a burger that is loaded with everything as long as it meets certain health requirements. Money is no object to them. Use Excel to answer this question Requirements: Must include at least one of each item and no more than six of each item Must use whole items (no half or partial servings) Final burger must contain no more than: 3,000 mg of sodium 50 g of fat 3,000 calories Must keep the servings of ketchup and lettuce the same Must keep the servings of pickles and tomatoes the same Must use exactly two buns a. What is the most expensive burger you can make that meets these requirements? b. What are the allocations of each ingredients.
9 A company had tax-deductible cash expenses of $900,000 last year, and the tax rate was 25%. What was the after-tax net cash outflow for these expenses? Select one: a. $675,000. b. $650,000. c. $390,000. d. $195,000.
Can you provide these formulas in Excel?
CH5: Starting and Managing Your Own Business 1) Explain and define the content of a Business Plan.
answer this
1. What is business model. 2. Example business model. 3. What is information system. 4. Example information system.