Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I would like you to solve only part 1. Overview: You are working as a business consultant, helping companies to better manage their costs. One

image text in transcribedimage text in transcribed

I would like you to solve only part 1.

Overview: You are working as a business consultant, helping companies to better manage their costs. One of your clients is Supremo Burritos, a chain of 100 quick service burrito stores located across the eastern US. Supremo Burritos has approached you because they would like to better understand their operating costs aside from their costs for food, labor and rent. You have been given a dataset which includes several pieces of data the client has collected over the past two years. Your goal is to use data analysis to help Supremo Burrito's management generate a cost equation that will be useful for predicting future "other operating costs for your client using the best available cost driver or drivers. Getting started: Download the Excel file from Canvas labeled Cost Behavior Case" that contains the dataset you will need. The dataset includes 24 months of data for Supremo Burritos' "Other Operating Costs as well as 6 possible drivers (the six possible cost drivers are Number of Transactions, Number of Items Sold, Direct Materials Cost, Direct Labor Cost, Direct Labor Hours and Revenue). The dataset also includes additional data on the underlying items that make up the total "Other Operating Costs. To complete the project you will need to follow the all the steps in parts 1, 2, 3 and 4 and write a memo as described in part 5. For Parts 1-3, Treat Other Operating Costs as a single cost pool Part 1: Estimate the basic cost equation for "Other Operating Costs using the High-low method separately for each possible cost driver Use the High-low method to determine the cost equation that expresses how monthly "Other Operating Costs behave in relation to that particular cost driver. Clearly show the two months you used to generate the High-low equation. Be sure to clearly state and label the resulting high- low equation for each possible cost driver. Number of Transactions Number of Items Sold Jan-19 1,507,046 5,817,198 Feb-19 1,603,174 6,412,696 Mar-19 1,546,554 6,279,009 Apr-19 1,504,934 5,929,440 May-19 1,500,128 6,105,521 Jun-19 1,445,337 5,752,441 Jul-19 1,454,791 5,557,302 Aug-19 1,511,497 6,015,758 Sep-19 1,524,889 5,962,316 Oct-19 1,485,374 6,000,911 Nov-19 1,527,204 6,154,632 Dec-19 1,537,212 5,872,150 Jan-20 1,582,214 6,819,342 Feb-20 1,547,040 5,863,282 Mar-20 1,521,721 6,406,445 Apr-20 1,504,175 6,167,118 May-20 1,594,684 6,267,108 Jun-20 1,474,974 5,752,399 Jul-20 1,507,636 6,045,620 Aug-20 1,521,370 5,857,275 Sep-20 1,605,573 6,374,125 Oct-20 1,635,514 6,852,804 Nov-20 1,557,065 6,165,977 Dec-20 1,551,456 6,174,795 Direct Materials Cost $6,599,629.03 $4,786,620.18 $4,973,528.00 $3,622,069.93 $5,196,605.23 $5,664,385.55 $5,851,651.31 $4,985,792.38 $4,012,832.57 $4,036,768.94 $4,948,145.04 $6,707,544.06 $6,846,509.60 $4,088,749.74 $4,942,982.44 $6,307,116.89 $5,288,567.84 $6,108,425.57 $6,292,155.74 $4,305,288.46 $7,057,222.77 $5,790,868.59 $5,414,834.51 $5,608,318.85 Direct Labor Cost $3,972,995.64 $4,265,633.45 $4,281,966.24 $3,836,858.56 $4,489,067.87 $3,458,678.32 $3,842,414.21 $3,796,025.11 $4,313,261.35 $3,934,307.90 $4,585,830.82 $4,744,293.06 $4,657,523.83 $4,107,389.90 $4,442,680.10 $4,091,295.91 $4,577,899.73 $4,766,494.18 $4,448,024.03 $4,153,322.60 $4,783,450.56 $4,510,192.81 $4,499,732.35 $4,377,732.66 Direct Labor Hours Revenue 248,185 $16,711,030.28 283,261 $17,670,504.46 272,937 $17,080,297.03 266,499 $16,654,051.12 309,446 $18,134,297.33 206,888 $ 16,073,448.24 234,112 $16,196,915.60 226,085 $18,373,606.38 279,655 $17,070,369.91 257,336 $16,638,416.86 299,101 $17,141,337.70 312,251 $18,826,081.64 297,430 $19,451,580.69 276,225 $17,511,873.98 296,604 $18,742,885.38 265,247 $17,101,717.66 286,521 $18,121,670.04 306,149 $18,269,617.95 272,822 $17,256,250.89 279,511 $17,396,713.81 332,836 $20,001,265.09 308,794 $18,846,354.92 279,852 $17,917,146.96 288,149 $19,438,657.66 Other Operating Costs $2,402,865.01 $2,691,247.72 $2,586,498.57 $2,441,163.20 $2,627,041.43 $2,411,103.28 $2,437,846.76 $2,464,073.40 $2,637,997.13 $2,498,316.27 $2,554,570.49 $2,582,052.29 $2,659,146.65 $2,445,726.17 $2,754,692.88 $2,276,436.05 $2,507,897.25 $2,534,443.63 $2,584,546.49 $2,402,516.84 $2,809,416.39 $2,814,013.77 $2,705,579.92 $2,564,894.09

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Sustainability Of Public Sector EntitiesThe Relevance Of Accounting Frameworks

Authors: Josette Caruana, Isabel Brusca, Eugenio Caperchione, Sandra Cohen, Francesca Manes Rossi

1st Edition

3030060365, 9783030060367

More Books

Students also viewed these Accounting questions

Question

What subject does FRS 1 deal with?

Answered: 1 week ago

Question

3. Raster images for screen projects need to be 72 dpi to scale.

Answered: 1 week ago