Balloons, cupcakes, and punch Labor (0.25 hour × $20 per hour) Overhead (0.25 hour × $40 per hour) Total cost per person 5 10 $22 %24 Month Labor-Hours Overhead Costs April May $ 65,000 1,400 71,000 1,800 June 2,100 73,000 July August September 2,200 76,000 1,650 67,000 1,725 68,000 October 1,500 66,500 November 1,200 60,000 December 1,900 72,500 Total 15,475 $619,000 Linda has recently become aware of regression analysis. She estimated the following regression equation with overhead costs as the dependent variable and labor-hours as the independent variable: y = $43,563 + $14.66X Required Plot the relationship between overhead costs and labor-hours. Draw the regression line and evaluate it using the criteria of economic plausibility, goodness of fit, and slope of the regression line. Using data from the regression analysis, what is the variable cost per person for a standard party? Linda Olson has been asked to prepare a bid for a 20-child birthday party to be given next month. Deter- mine the minimum bid price that Linda would be willing to submit to recoup variable costs. 1. 2. 3.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question

Regression analysis, service company. (CMA, adapted) Linda Olson owns a professional character business in a large metropolitan area. She hires local college students to play these characters at children’s parties and other events. Linda provides balloons, cupcakes, and punch. For a standard party the cost on a per-person basis is as follows:

Linda is quite certain about the estimates of the materials and labor costs, but is not as comfortable with the overhead estimate. The overhead estimate was based on the actual data for the past 9 months, which are presented here. These data indicate that overhead costs vary with the direct labor-hours used. The $40 estimate was determined by dividing total overhead costs for the 9 months by total labor-hours.

Balloons, cupcakes, and punch
Labor (0.25 hour × $20 per hour)
Overhead (0.25 hour × $40 per hour)
Total cost per person
5
10
$22
%24
Transcribed Image Text:Balloons, cupcakes, and punch Labor (0.25 hour × $20 per hour) Overhead (0.25 hour × $40 per hour) Total cost per person 5 10 $22 %24
Month
Labor-Hours
Overhead Costs
April
May
$ 65,000
1,400
71,000
1,800
June
2,100
73,000
July
August
September
2,200
76,000
1,650
67,000
1,725
68,000
October
1,500
66,500
November
1,200
60,000
December
1,900
72,500
Total
15,475
$619,000
Linda has recently become aware of regression analysis. She estimated the following regression equation
with overhead costs as the dependent variable and labor-hours as the independent variable:
y = $43,563 + $14.66X
Required
Plot the relationship between overhead costs and labor-hours. Draw the regression line and evaluate it
using the criteria of economic plausibility, goodness of fit, and slope of the regression line.
Using data from the regression analysis, what is the variable cost per person for a standard party?
Linda Olson has been asked to prepare a bid for a 20-child birthday party to be given next month. Deter-
mine the minimum bid price that Linda would be willing to submit to recoup variable costs.
1.
2.
3.
Transcribed Image Text:Month Labor-Hours Overhead Costs April May $ 65,000 1,400 71,000 1,800 June 2,100 73,000 July August September 2,200 76,000 1,650 67,000 1,725 68,000 October 1,500 66,500 November 1,200 60,000 December 1,900 72,500 Total 15,475 $619,000 Linda has recently become aware of regression analysis. She estimated the following regression equation with overhead costs as the dependent variable and labor-hours as the independent variable: y = $43,563 + $14.66X Required Plot the relationship between overhead costs and labor-hours. Draw the regression line and evaluate it using the criteria of economic plausibility, goodness of fit, and slope of the regression line. Using data from the regression analysis, what is the variable cost per person for a standard party? Linda Olson has been asked to prepare a bid for a 20-child birthday party to be given next month. Deter- mine the minimum bid price that Linda would be willing to submit to recoup variable costs. 1. 2. 3.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Performance measurements
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
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education