(16 DeMarco Company is developing a cost formula for its packing activity. Discussion with the workers in the Packing Department has revealed that packing costs are associated with the number of customer orders, the size of the orders, and the relative fraglity of the Items (more fragile items must be specially wrapped in bubble wrap and Styrofoam). Data for the past 20 months have been gathered: Packing Cost Number Weight of Orders Number of Month of Orders Fragile Items 1 S 45,000 11,200 24,640 31,220 1.120 2 58,000 14,000 1,400 3 39,000 10,500 18,000 1,000 35.600 9.000 19,350 850 4,000 90,000 126,000 90,600 63,000 79,000 155,000 21,000 46,200 31,000 64,000 60,000 5,500 1,800 750 7 20,000 15,000 16,000 40,000 8 40,000 59,000 1,500 88,000 249,700 10 2,500 11,800 14,000 900 11 450,000 113,500 12 13 640,000 41,000 54,000 58,000 58,090 80,110 123,000 108,000 76,000 150,000 390,000 10,000 14,000 15,000 14,500 23,000 29,400 30,000 31,900 50,000 14 890 15 1,500 1,340 3,000 2,000 1,900 16 17 18,000 18 30,000 75,000 19 63,450 27,000 18,000 20 41,400 1,430 Required: Using the method of least squares, run a regression using the number of orders as the independent variable. Run a multiple regression using three independent variables: the number of orders, the weight of orders, and the number of fragile items. Which regression equation is better? Why? Predict the total packing cost for 25,000 orders, weighing 40,000 pounds, with 4,000 fragile items. How much would the cost estimated for Requirement 3 change if the 25,000 orders weighed 40,000 pounds, but only 2,000 were fragile items?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
(16
DeMarco Company is developing a cost formula for its packing activity.
Discussion with the workers in the Packing Department has revealed that
packing costs are associated with the number of customer orders, the size of
the orders, and the relative fraglity of the Items (more fragile items must be
specially wrapped in bubble wrap and Styrofoam). Data for the past 20
months have been gathered:
Packing
Cost
Number
Weight
of Orders
Number of
Month
of Orders
Fragile Items
1
S 45,000
11,200
24,640
31,220
1.120
2
58,000
14,000
1,400
3
39,000
10,500
18,000
1,000
35.600
9.000
19,350
850
4,000
90,000
126,000
90,600
63,000
79,000
155,000
21,000
46,200
31,000
64,000
60,000
5,500
1,800
750
7
20,000
15,000
16,000
40,000
8
40,000
59,000
1,500
88,000
249,700
10
2,500
11,800
14,000
900
11
450,000
113,500
12
13
640,000
41,000
54,000
58,000
58,090
80,110
123,000
108,000
76,000
150,000
390,000
10,000
14,000
15,000
14,500
23,000
29,400
30,000
31,900
50,000
14
890
15
1,500
1,340
3,000
2,000
1,900
16
17
18,000
18
30,000
75,000
19
63,450
27,000
18,000
20
41,400
1,430
Required:
Using the method of least squares, run a regression using the number of
orders as the independent variable.
Run a multiple regression using three independent variables: the number of
orders, the weight of orders, and the number of fragile items. Which
regression equation is better? Why?
Predict the total packing cost for 25,000 orders, weighing 40,000 pounds, with
4,000 fragile items.
How much would the cost estimated for Requirement 3 change if the 25,000
orders weighed 40,000 pounds, but only 2,000 were fragile items?
Transcribed Image Text:(16 DeMarco Company is developing a cost formula for its packing activity. Discussion with the workers in the Packing Department has revealed that packing costs are associated with the number of customer orders, the size of the orders, and the relative fraglity of the Items (more fragile items must be specially wrapped in bubble wrap and Styrofoam). Data for the past 20 months have been gathered: Packing Cost Number Weight of Orders Number of Month of Orders Fragile Items 1 S 45,000 11,200 24,640 31,220 1.120 2 58,000 14,000 1,400 3 39,000 10,500 18,000 1,000 35.600 9.000 19,350 850 4,000 90,000 126,000 90,600 63,000 79,000 155,000 21,000 46,200 31,000 64,000 60,000 5,500 1,800 750 7 20,000 15,000 16,000 40,000 8 40,000 59,000 1,500 88,000 249,700 10 2,500 11,800 14,000 900 11 450,000 113,500 12 13 640,000 41,000 54,000 58,000 58,090 80,110 123,000 108,000 76,000 150,000 390,000 10,000 14,000 15,000 14,500 23,000 29,400 30,000 31,900 50,000 14 890 15 1,500 1,340 3,000 2,000 1,900 16 17 18,000 18 30,000 75,000 19 63,450 27,000 18,000 20 41,400 1,430 Required: Using the method of least squares, run a regression using the number of orders as the independent variable. Run a multiple regression using three independent variables: the number of orders, the weight of orders, and the number of fragile items. Which regression equation is better? Why? Predict the total packing cost for 25,000 orders, weighing 40,000 pounds, with 4,000 fragile items. How much would the cost estimated for Requirement 3 change if the 25,000 orders weighed 40,000 pounds, but only 2,000 were fragile items?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 5 images

Blurred answer
Knowledge Booster
Cost estimation
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