Question: Kidstuff, Inc., was started 10 years ago by selling childrens clothing through catalogs. Helena Cence, Kidstuffs controller, had determined that the cost of filling and
Kidstuff, Inc., was started 10 years ago by selling childrens clothing through catalogs. Helena Cence, Kidstuffs controller, had determined that the cost of filling and shipping orders was fairly consistently related to the number of orders. She had been using the following formula to describe monthly order filling costs:
Order filling cost = $7,800 + $7.50 Ã orders
Lately, however, Helena noticed that order filling costs varied widely and did not seem to follow the above relationship. After a number of discussions with order pickers and fillers, Helena determined that Kidstuffs expansion into childrens toys had made order filling a more complex operation. Number of orders was still an important variable, but so were the number of categories included in an order (an order for just clothing was quicker to pick, fill, and pack than an order with both clothing and toys) and whether or not any items needed to be gift wrapped. Helena ran a multiple regression on the past 24 months of data for Kidstuff for three variables: the number of orders, the number of complex orders (orders with both clothing and toys), and the number of gifts (the number of gift-wrapped items). The following printout was obtained:
.png)
Required:
1. Write out the cost equation for Kidstuffs monthly order filling cost.
2. If Kidstuff expects to have 300 orders next month (65 with both clothing and toys) and expects that 100 items must be gift wrapped, what are the anticipated order filling costs?
3. Calculate a 99 percent confidence interval for the prediction made in Requirement 2.
4. What does R2 mean in this equation? Overall, what is your evaluation of the cost equation that was developed for the cost of order filling? Suppose that Kidstuff charges an extra $2.50 to gift wrap an item. How might Helena use the results of the regression equation to see whether or not the $2.50 charge isappropriate?
Standard Error of Parameter Parameter Estomate t statistic Pr> t 0.0001 0.0050 0.0050 0.0250 9,320 5.14 Intercept Number of orders Number of complex orders Number of gifts 93.00 3.60 5.58 2.96 479.00 1.56 2.00 0.75 2.06 1.30 S 150 Observations: 24
Step by Step Solution
3.46 Rating (159 Votes )
There are 3 Steps involved in it
1 Y 9320 514 X 1 206 X 2 130 X 3 where Y Total cost of order filling X 1 Number of orders X 2 ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
101-B-M-A-C-B (487).docx
120 KBs Word File
