Boom Company assembles and sells portable speaker systems in the midwest. In an effort to improve...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Boom Company assembles and sells portable speaker systems in the midwest. In an effort to improve the planning and control of shipping expenses, management is trying to determine which of three variables-units shipped, weight shipped, or sales value of units shipped-has the closest relationship with shipping expenses. The following information is available: Sales Value of Shipping Weight Units Shipped Shipped (Ibs.) Units Shipped Expenses Month May 6,000 9,300 $200,000 $8,960 June 10,000 12,000 220,000 12,320 July 8,000 12,150 160,000 10,400 August 14,000 15,000 228,000 16,640 September 12,000 10,500 280,000 13,760 October 9,000 12,000 320,000 13,120 Required a. With the aid of a spreadsheet program, determine whether units shipped, weight shipped, or sales value of units shipped has the closest relationship with shipping expenses. Complete the r-squared values between each possible independent variable and shipping expenses: Round answers to two decimal places. Units shipped 0.92 V Weight shipped I 0.59 Sale value 0.23 Based on the coefficient of determination, units shipped + v has the closest relationship with shipping expenses. b. Using the independent variable that appears to have the closest relationship to chinnin O douolen cost octimatingnauation for totl monthhe chinning Based on the coefficient of determination, units shipped : has the closest relationship with shipping expenses. b. Using the independent variable that appears to have the closest relationship to shipping expenses, develop a cost-estimating equation for total monthly shipping expenses. Round answers to two decimal places. Shipping expenses = $ 4,040 + $ 0.9 c. Use the equation developed in requirement (b) to predict total shipping expenses in a month when 5,000 units, weighing 7,000 lbs., with a total sales value of $114,000 are shipped. Round answers to two decimal places. $ 8,000 Boom Company assembles and sells portable speaker systems in the midwest. In an effort to improve the planning and control of shipping expenses, management is trying to determine which of three variables-units shipped, weight shipped, or sales value of units shipped-has the closest relationship with shipping expenses. The following information is available: Sales Value of Shipping Weight Units Shipped Shipped (Ibs.) Units Shipped Expenses Month May 6,000 9,300 $200,000 $8,960 June 10,000 12,000 220,000 12,320 July 8,000 12,150 160,000 10,400 August 14,000 15,000 228,000 16,640 September 12,000 10,500 280,000 13,760 October 9,000 12,000 320,000 13,120 Required a. With the aid of a spreadsheet program, determine whether units shipped, weight shipped, or sales value of units shipped has the closest relationship with shipping expenses. Complete the r-squared values between each possible independent variable and shipping expenses: Round answers to two decimal places. Units shipped 0.92 V Weight shipped I 0.59 Sale value 0.23 Based on the coefficient of determination, units shipped + v has the closest relationship with shipping expenses. b. Using the independent variable that appears to have the closest relationship to chinnin O douolen cost octimatingnauation for totl monthhe chinning Based on the coefficient of determination, units shipped : has the closest relationship with shipping expenses. b. Using the independent variable that appears to have the closest relationship to shipping expenses, develop a cost-estimating equation for total monthly shipping expenses. Round answers to two decimal places. Shipping expenses = $ 4,040 + $ 0.9 c. Use the equation developed in requirement (b) to predict total shipping expenses in a month when 5,000 units, weighing 7,000 lbs., with a total sales value of $114,000 are shipped. Round answers to two decimal places. $ 8,000
Expert Answer:
Answer rating: 100% (QA)
To determine which component has the closed relationship with the shipping expense... View the full answer
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these mathematics questions
-
Noble Amazon sells books online. Management is trying to determine the best sites for the company's warehouses. The five potential sites under consideration are listed in the first column of the...
-
Top management is trying to determine a consistent but fair valuation system to use to evaluate each of its four divisions. This years performance data are summarized as follows: Required A. Which...
-
A bank is trying to determine which of two machines to rent for check processing. Machine 1 rents for $10,000 per year and processes 1000 checks per hour. Machine 2 rents for $15,000 per year and...
-
You are asked to evaluate the following two projects for Boring Corporation using the NPV method combined with the PI approach, which project would you select? Use a discount rate of 10 percent....
-
The maximum safe pressure that a certain 4.00-L vessel can hold is 3.50 atm. If the vessel contains 0.410 mol of gas, what is the maximum temperature (in degrees Celsius) to which this vessel can be...
-
The line integral of the magnetic field around a certain closed path is initially \(L\). The current that penetrates this path is then doubled. What can you say about the current through the path if...
-
The composite pressure vessel in Problem 8.6 is subjected to an internal pressure that varies sinusoidally with time according to the relationship \(p(t)=P_{0}\) \(\sin t\), and the principal complex...
-
Zimmerman Clothiers manufactures womens business suits. The company uses a standard cost accounting system. In March 2014, 15,700 suits were made. The following standard and actual cost data applied...
-
Liquidity Ratios Debt Management Ratios Profitability Ratios Market Value Ratio Current Ratio Days Sales in Receivables Debt/Equity Long Term Debt/Capital Return on Assets Return on Equity Net Profit...
-
A soft drink bottling company is interested in controlling its filling operation. Random samples of size 4 are selected and the fill weight is recorded. Table 7-17 shows the data for 24 samples. The...
-
The circuit below shows a 3-phase Y-connected system feeds a balanced Y-conected load (positive sequence), Zy = 6 + j8 Q, and Vab = (400 + 0.4*N) 230 Vrms, answer questions (6 - 8). 0.20 j0.2 n A a...
-
An ac resistance is higher than a dc resistance. (a) True (b) False
-
Along with limiting corona and its effects, particularly for EHV lines, the maximum ground-level electric field strength needs to be controlled to avoid the shock hazard. (a) True (b) False
-
An estate with distributable net income of $100,000 distributes the following assets to a beneficiary in December of 2019: a. What is the beneficiary's basis in the distributed assets? b. What would...
-
The propagation constant, which is a complex quantity in general, has units of ________, and the characteristic impedance has units of ________.
-
Does an open- \(\Delta\) operation, the kVA rating compared to that of the original three-phase bank is (a) \(2 / 3\) (b) \(58 \%\) (c) 1
-
A spring gun with spring constant 4 N / m is compressed 2 meters from its natural length and then shoots a ball of 0 . 0 1 kg . What is the speed of the ball out of the gun ( in m / s ) ?
-
SBS Company have received a contract to supply its product to a Health Care Service Hospital. The sales involve supplying 1,250 units every quarter, the sales price is RM 85 per unit. The Client...
-
You are given the following linear programming model in algebraic form, with x1 and x2 as the decision variables: Minimize Cost = 40x1 + 50x2 Subject to Constraint 1: 2x1 + 3x2 ( 30 Constraint 2: x1...
-
Greg is making plans to open a new fast-food restaurant soon. He is estimating that customers will arrive randomly at a mean rate of 150 per hour during the busiest times of the day. He is planning...
-
Weenies and Buns is a food processing plant that manufactures hot dogs and hot dog buns. They grind their own flour for the hot dog buns at a maximum rate of 200 pounds per week. Each hot dog bun...
-
What are the three main considerations involved in managing subcontractors?
-
Why is float a valuable resource, and why is free float more valuable than total float?
-
Describe the situation for which but-for or collapsed as-built analysis is most appropriate.
Study smarter with the SolutionInn App