Question 1 - High-low method Java Joe has been in business for one year and has...

Question

Question 1 - High-low method Java Joe has been in business for one year and has collected the following cost data for utiliti

Required: Explain to Joe whether each of the preceding costs is variable, fixed, or mixed and why. Using the high-low method,

Question 2 - Selecting a cost driver Iggy Hospital is a small animal hospital that specializes in minor surgeries. Timmy Snyd

Required: (a) Prepare a scatterplot using the number of procedures performed. Use Excel to fit a straight line through the da

Question 3 - Activity-based costing Abby, Barry, and Chris have decided to share an apartment in Playa Vista for the coming s

Question 1 - High-low method Java Joe has been in business for one year and has collected the following cost data for utilities. Joe asks you to help him determine a cost equation to estimate monthly utility costs. Electricity Bill January February March April May kWh Used 2,400 2,800 3,660 2,700 3,920 4,160 3,480 3,980 4,200 4,100 3,960 4,220 Telephone Minutes Used 2,200 $184.00 2,120 $182.40 2,480 $189.60 1,960 $179.20 2,800 $196.00 2,880 $197.60 2,340 $186.80 2,620 $192.40 2,560 $191.20 2,380 $187.60 2,100 $182.00 2,700 $97.00 Bill $720.00 $840.00 $1,098.00 $810.00 $1,176.00 $1,248.00 $1,044.00 $1,194.00 $1,260.00 $1,230.00 $1,188.00 $1,266.00 June July August September October November December Water Gallons Used Bill 61,120 $120.00 53,400 $120.00 62.900 $120.00 59,930 $120.00 61,136 $120.00 51,080 $120.00 65,380 $120.00 62,444 $120.00 67,080 $120.00 63,940 $120.00 57,200 $120.00 68,200 $120.00

Required: Explain to Joe whether each of the preceding costs is variable, fixed, or mixed and why. Using the high-low method, determine the cost equation for each cost. Combine the cost equations you determined in (b) to obtain a monthly utility cost equation for Java Joe's. Joe expects to use 3,600 kilowatt hours of electricity, make 2,400 minutes of telephone calls, and use 60,000 gallons of water next month. Help Joe estimate the total utility cost for next month.

Question 2 - Selecting a cost driver Iggy Hospital is a small animal hospital that specializes in minor surgeries. Timmy Snyder, Iggy's CEO, Is concerned about the hospital's consumption of medical supplies. Timmy asks Tommy Poon, Iggy's CFO, to better understand the behavior of this cost. Tommy believes that there are two potential cost drivers for the hospital's medical supplies costs - the total number of procedures performed and the number of patient-hours generated by Iggy. Tommy has collected the following data. Number of Procedures 32 Number of Patient-Hours 200 410 160 400 340 320 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12 Week 13 Week 14 Week 15 Medical Supplies Cost $10,600 $23,000 $8,400 $23,800 $19,300 $18,000 $21,000 $25,000 $13,500 $16,500 $9,200 $22,200 $7,800 $12,700 $22,500 350 420 180 270 150 370 130 240 380

Required: (a) Prepare a scatterplot using the number of procedures performed. Use Excel to fit a straight line through the data points. Write down the cost equation. Prepare a scatterplot using the number of patient-hours. Use Excel to fit a straight line through the data points. Write down the cost equation. Evaluate the regression models you obtained in (a) and (b). Determine whether number of procedures performed or number of patient-hours is a better cost driver for predicting medical supplies costs. Explain. Timmy expects that the hospital will perform 45 procedures and generate 480 patient-hours in week 16. Using the cost driver you chose in (c), help Timmy estimate the medical supplies costs for week 16.

Question 3 - Activity-based costing Abby, Barry, and Chris have decided to share an apartment in Playa Vista for the coming school year. The rent will be $3,000 per month. There are two bedrooms in the apartment. Barry and Chris will share a bedroom and Abby will have her own. They estimate that groceries will cost $600 per month and that Barry and Chris will each eat 20 pounds of grocerles and Abby will eat 10 pounds. Internet access will cost $60 per month. Abby uses the Internet 10 hours day and Barry uses the Internet 5 hours a day. Chris does not use the internet at all. Required: (a) Barry suggests that they share the costs equally. Calculate the total cost that each person would pay if they share the costs equally. Chris doesn't like Barry's Idea and suggests that each cost be allocated to each person based on their consumption of the activity. List the activity measure for each cost. Calculate the total cost that each person would pay based on their consumption of the activities.

 · Answer

Q1.
(a) Electricity Cost is a variable cost since it directly varies with kWH used. Rate per kWH is same at all levels. Variable cost per unit remains constant for all levels of activity

Telephone cost is a mixed cost since this cost changes with change in level of minutes but not in direct proportion to that, It is a mixed of variable and fixed Cost

Water bill is fixed cost, since total cost remains same at all levels of activity

(b)
Electricity
Variable cost = ($1266-720)/(4220-2400) = $0.30 per unit
Fixed Cost = $720 - 2400 x 0.30 = 0
Cost Equation = $0.30 x kWH

Telephone bill
Variable cost = ($197.60-179.20)/(2880-1960) = $0.02 per minute
Fixed Cost = $197.60 - 2880 x 0.02 = $140
Cost Equation = $140 + $0.02 x minutes

Water bill
Cost Equation = $120

(c) Combined Cost equation = $260 + $0.30 x kWH + $0.02 x minutes

(d) Total Cost = $260 + 3600 x $0.30 + 2400 x $0.02 = $1388

As per HOMEWORKLIB RULES we are supposed to answer 1 question, i have solved 1 , so kindly post others separately

.

Question 1 - High-low method Java Joe has been in business for one year and has...

Question:

Answers

Similar Solved Questions

At January 1, 2021, Brainard Industries, Inc., owed Second BancCorp $16 million under a 10% note...

13- Today, I bought 1 put contract on GM with one-year to maturity with an exercise...

The formula 3-C models inflation, where the value today, the annual inflation rate (in decimal form),...

Define and describe each of the following Requirements to be president President’s cabinet Executive order Pardon...

The magnitude of the force on a magnetic dipole μ aligned with a non uniform magnetic...

Find Zab where the circut is operating at f= 500 hz 5. (10 points) Find ZAB...

Instructions Amount Descriptions and Labels Statement of Cash Flows (Partial) Instructions Statement of Cash Flows (Partial)...

NEED JOURNAL ENTRIES FOR EVENT 4 AND 5 AND MARKED IF THEY ARE A ASSET SOURCE,...

While hanging out in Lab, you decide to conduct another calorimetry experiment, but this time, you...

5. With the booming world economy, the 2x4 lumber consumed in the construction industry is considerably...

Kinesology crises using arrows to show Draw the starting and ending position of the following ROM...

Please answer all parts ing from nanocoulombs to microcoulombs. k here for iled view m Status...

Discuss the change in potential energy when a molecule is formed from two atoms with the...

Stats LN Online- Spring 18-CRN 22608 Homework: 8.3 HW Score: 0 of 1 pt 8.3.17 Katie...

Can u guys plz answer to my questions

Franklin Company uses ABC to account for its chrome wheel manufacturing process. Company managers have identified...

Predict the major product for the following reaction. HNOJHSO осн. O Осно, OCH, O OCH о...

3. Look around you, find an appliance, and look for its power rating. What is the...