Required information [The following information applies to the questions displayed below.] Caiman Distribution Partners is the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Required information [The following information applies to the questions displayed below.] Caiman Distribution Partners is the Brazilian distribution company of a U.S. consumer products firm. Inflation in Brazil has made bidding and budgeting difficult for marketing managers trying to penetrate some of the country's rural regions. The company expects to distribute 450,000 cases of products in Brazil next month. The controller has classified operating costs (excluding costs of the distributed product) as follows. Account Supplies Supervision Truck expense Building leases Operating Cost $1,582,000 201,000 1,380,000 872,000 210,000 Utilities Warehouse labor 838,000 Equipment leases 756,000 Data processing equipment 962,000 Other Total 835,000 $7,636,000 Behavior All variable $ 155,000 Fixed $178,000 Fixed $ 542,000 Fixed $106,000 Fixed $ 147,000 Fixed $ 611,000 Fixed All fixed $345,000 Fixed Although overhead costs were related to revenues throughout the company, the experience in Brazil suggested to the managers that they should incorporate information from a published index of Brazilian prices in the distribution sector to forecast overhead in a manner more likely to capture the economics of the business Following instructions from the corporate offices, the controller's office in Brazil collected the following information for monthly operations from last year. Month 1 Cases 247,000 Price Index Operating Costs 114 2 352,000 109 $5,699,171 5,806,670 3 248,000 127 5,849,937 4 421,000 128 5,927,649 5 347,000 114 5,939,167 6 371,000 131 6,043,396 7 441,000 127 5,918,527 8 469,000 143 6,133,900 9 330,000 134 6,126,162 10 403,000 140 6,186,657 11 409,000 133 12 470,000 145 6,208,831 6,362,287 These data are considered representative for both past and future operations in Brazil. e-1. Using Excel, calculate the simple regression of operating costs on cases shipped and enter the regression coefficients. c-2. Compute the estimation of operating costs assuming that 450.000 cases will be shipped next month by using the results of a simple regression of operating costs on cases shipped. Required information [The following information applies to the questions displayed below.] Caiman Distribution Partners is the Brazilian distribution company of a U.S. consumer products firm. Inflation in Brazil has made bidding and budgeting difficult for marketing managers trying to penetrate some of the country's rural regions. The company expects to distribute 450,000 cases of products in Brazil next month. The controller has classified operating costs (excluding costs of the distributed product) as follows. Account Supplies Supervision Truck expense Building leases Operating Cost $1,582,000 201,000 1,380,000 872,000 210,000 Utilities Warehouse labor 838,000 Equipment leases 756,000 Data processing equipment 962,000 Other Total 835,000 $7,636,000 Behavior All variable $ 155,000 Fixed $178,000 Fixed $ 542,000 Fixed $106,000 Fixed $ 147,000 Fixed $ 611,000 Fixed All fixed $345,000 Fixed Although overhead costs were related to revenues throughout the company, the experience in Brazil suggested to the managers that they should incorporate information from a published index of Brazilian prices in the distribution sector to forecast overhead in a manner more likely to capture the economics of the business Following instructions from the corporate offices, the controller's office in Brazil collected the following information for monthly operations from last year. Month 1 Cases 247,000 Price Index Operating Costs 114 2 352,000 109 $5,699,171 5,806,670 3 248,000 127 5,849,937 4 421,000 128 5,927,649 5 347,000 114 5,939,167 6 371,000 131 6,043,396 7 441,000 127 5,918,527 8 469,000 143 6,133,900 9 330,000 134 6,126,162 10 403,000 140 6,186,657 11 409,000 133 12 470,000 145 6,208,831 6,362,287 These data are considered representative for both past and future operations in Brazil. e-1. Using Excel, calculate the simple regression of operating costs on cases shipped and enter the regression coefficients. c-2. Compute the estimation of operating costs assuming that 450.000 cases will be shipped next month by using the results of a simple regression of operating costs on cases shipped.
Expert Answer:
Answer rating: 100% (QA)
Answer To calculate the simple regression of operating costs on cases shipped using Excel you can fo... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Jason hired Neil to replace a motor in his car, and the original estimate of the repair was $3,500. After beginning the repair, it was determined that the repair would cost an additional $400. Jason...
-
The chart of accounts of XYZ Company includes the following accounts: 101 Cash; 210 Wages Payable; 310 Owner, Capital; 401 Sales; and 602 Office Expense. Based on the selected accounts of XYZ...
-
1. As shown by point D in Fig 3.1, the volume of an ideal diatomic gas is 2.00L at standard condition (STP, T=273.15K, P=101.3kPa). The gas is heated to A with its volume conserved, expands...
-
On February 10, 2014, finance. yahoo. com/ bonds quoted a bond price of 140.2 for Ford Motor Company s 9.3 percent bonds maturing on March 1, 2030. Were the bonds listed at a discount or premium?...
-
Palmer Industries prepares annual financial statements and adjusts its accounts only at the end of the year. The following information is available for the year ended December 31, 2017: a. Palmer...
-
According to current views of managerial work, it is highly unlikely that an effective manager will ____________. (a) engage in extensive networking (b) have good interpersonal skills (c) spend a lot...
-
Distinguish between operating mergers and financial mergers.
-
The Oncology Department at Greenhills Hospital provides only two services: Service X and service Y. Last year, the volume of service X and Y provided amounted to 4,000 and 6,000, respectively. The...
-
Peter who is on a moving trolley throws a ball to John (who is stationary) as shown in Fig. Q2a. The trolley is moving at a constant speed of 3.0 m/s to the right. If the ball leaves the boy with a...
-
How do you balance the preservation of traditional organizational values with the need for innovation and adaptability in a rapidly changing business environment?
-
A firm has the following probability distribution for annual losses due to vandalism: Loss Amount $0 $5,000 Probability 0.65 0.30 $10,000 The firm is considering three options: 0.05 1. Partial...
-
Miller Company's contribution format income statement for the most recent month is shown below: Sales (40,000 units) Variable expenses Total $ 280,000 160,000 Contribution margin 120,000 Fixed...
-
Memphis Wholesale Market applies the lower of cost or net realizable valuation to individual products and has collected the following data: Product A Product B Product C Selling price Cost $ 93 Costs...
-
discuss the role of inclusive leadership in driving organizational change and creating environments where individuals from diverse backgrounds feel valued, respected, and empowered to contribute...
-
the marketing tasks of an international marketer differ form thayt of a domestic marketer asthe
-
B made an issue of 150,000 $1 ordinary shares at a premium of 20% the proceeds of which is received by cheque. What is the correct journal to record this? A. Bank Share capital Share premium B. Bank...
-
A company often test-markets a proposed product in a specific area or location. Suppose that you wish to test-market your new, revolutionary SuperWax car wax, which requires only one application for...
-
The idea for New Belgium Brewing Company began with a bicycling trip through Belgium, where some of the worlds finest ales have been brewed for centuries. As Jeff Lebesch, a U.S. electrical engineer,...
-
It is helpful to think of a total product offering as having a combination of three interdependent elements: the core product itself, its supplemental features, and its symbolic or experiential...
Study smarter with the SolutionInn App