subject
Business, 06.03.2021 01:00 zlyzoh

Pilot Shop is a catalog business providing a wide variety of aviation products to pilots throughout the world. Maynard Shephard, the recently hired assistant controller, has been asked to develop a cost function to forecast shipping costs. The previous assistant controller had forecast shipping department costs each year by plotting cost data against direct labor hours for the most recent 12 months and visually fitting a straight line through the points. The results were not satisfactory. After discussions with the shipping department personnel, Maynard decided that shipping costs could be more closely related to the number of cartons shipped. He based his conclusion on the fact that 10 months ago, the shipping department added some automated equipment. Furthermore, he believes that using linear regression analysis will improve the forecasts of shipping costs. Cost data for the shipping department have been accumulated for the last 25 weeks. He ran two regression analyses of the data, one using direct labor hours, and one using the number of cartons shipped. The information from the two linear regressions follows: Regression 1 Regression 2
SC = 804.3 + 15.68DL SC = 642.9 + 3.92NR
R-squared 0.365 0.729
Standard error of the estimate 2.652 1.884
t-value 1.89 3.46

where:
SC = total shipping department costs DL = total direct labor-hours
NR = number of cartons shipped

Required
a. Identify which cost function (regression 1 or regression 2) Pilot Shop should adopt for forecasting total shipping department costs and explain why.
b. If Pilot Shop projects that 600 orders will be filled the coming week, calculate the total shipping depart- ment costs using the regression you selected in requirement a.
c. Explain two or three important limitations of the regression you selected in requirement a, and identify one or two ways to address the limitations. Specifically include in your discussion the effect, if any, of the global nature of Pilot Shop’s business.

ansver
Answers: 2

Another question on Business

question
Business, 21.06.2019 21:30
In its 2016 annual report, caterpillar inc. reported the following (in millions): 2016 2015 sales $38,537 $47,011 cost of goods sold 28,309 33,546 as a percentage of sales, did caterpillar's gross profit increase or decrease during 2016? select one: a. gross profit increased from 26.8% to 28.6% b. gross profit decreased from 28.6% to 26.5% c. gross profit increased from 71.4% to 73.2% d. gross profit decreased from 73.2% to 71.4% e. there is not enough information to answer the question.
Answers: 2
question
Business, 21.06.2019 23:00
You and your new australian bride matilda, are applying for a loan and are required to submit a balance sheet with your net worth. you own a 2008 toyota camry that you bought last month for $9,995. the kelly blue book value for this car is $13,995. you owe $8,150 on the car loan for the camry. you pay off your visa credit card every month and have not paid any credit card interest this year. the current visa credit card balance is $3,522, and the next statement is due in 15 days. you have a student loan balance of $6,500. you presently have $425 in your checking account and $1,540 in your savings account. you own 100 shares of ibm stock that you purchased for $85.50 per share. one share of ibm is now selling for $158.42. you own computers and other electronics that you purchased for $4,100 but could probably sell today on e-bay for $1,800. your gross income is $80,000 per year. what is your current net worth? (see wb ch. 2 example 2.3)
Answers: 1
question
Business, 22.06.2019 06:30
Double corporation acquired all of the common stock of simple company for
Answers: 2
question
Business, 22.06.2019 11:00
Down under products, ltd., of australia has budgeted sales of its popular boomerang for the next four months as follows: unit salesapril 74,000may 85,000june 114,000july 92,000the company is now in the process of preparing a production budget for the second quarter. past experience has shown that end-of-month inventory levels must equal 10% of the following month’s unit sales. the inventory at the end of march was 7,400 units.required: prepare a production budget by month and in total, for the second quarter.
Answers: 3
You know the right answer?
Pilot Shop is a catalog business providing a wide variety of aviation products to pilots throughout...
Questions
question
Mathematics, 27.09.2020 20:01
question
Spanish, 27.09.2020 20:01
question
Mathematics, 27.09.2020 20:01
question
Mathematics, 27.09.2020 20:01
question
Mathematics, 27.09.2020 20:01