# 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 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.

#### Similar Solved Questions

##### Define and describe each of the following Requirements to be president President’s cabinet Executive order Pardon...
Define and describe each of the following Requirements to be president President’s cabinet Executive order Pardon Twenty-second Amendment Twenty-fifth Amendment Line-item veto Executive privilege U.S. v. Nixon Vice President First Lady...
##### The magnitude of the force on a magnetic dipole μ aligned with a non uniform magnetic...
The magnitude of the force on a magnetic dipole μ aligned with a non uniform magnetic field in the positive x-direction is Fx- Suppose two flat loops of wire each have radius R and carry a current dx (a) The loops are parallel to each other and share the same axis. They are separated by a variabl...
##### Find Zab where the circut is operating at f= 500 hz 5. (10 points) Find ZAB...
Find Zab where the circut is operating at f= 500 hz 5. (10 points) Find ZAB where the circuit is operating at f = 500Hz. 100 uF 100 mF 120k12 W 150 mF = 120 pF 270 mH 3 100 mH...
##### Instructions Amount Descriptions and Labels Statement of Cash Flows (Partial) Instructions Statement of Cash Flows (Partial)...
Instructions Amount Descriptions and Labels Statement of Cash Flows (Partial) Instructions Statement of Cash Flows (Partial) Tidwell Company experienced the following during 20X1: Prepare the net cash from financing activities section of the statement of cash flows. (Note: Use a minus sign to indica...
##### NEED JOURNAL ENTRIES FOR EVENT 4 AND 5 AND MARKED IF THEY ARE A ASSET SOURCE,...
NEED JOURNAL ENTRIES FOR EVENT 4 AND 5 AND MARKED IF THEY ARE A ASSET SOURCE, ASSET USE, ASSET EXCHANGE OR CLAIMS EXCHANGE ACC 211 bought equipment for $6,000 on January 1st. The furniture had a 4% discount. Freight cost amounted to$1,600. ACC 211 had to hire a specialist to adjust the equipment be...
##### While hanging out in Lab, you decide to conduct another calorimetry experiment, but this time, you...
While hanging out in Lab, you decide to conduct another calorimetry experiment, but this time, you want to do it on a bit larger scale. You place 3.8 kg of water in a large aluminum can that has a mass of 15 kg. You heat the water and can up to an initial temperature of 80◦ C, and then slowly ...
##### 5. With the booming world economy, the 2x4 lumber consumed in the construction industry is considerably...
5. With the booming world economy, the 2x4 lumber consumed in the construction industry is considerably increasing. To obtain the 2x4's that meet the quality requirements the milling system for 2x4's needs to be effective. The following reliability diagram is established. What is the reliabi...
##### Kinesology crises using arrows to show Draw the starting and ending position of the following ROM...
kinesology crises using arrows to show Draw the starting and ending position of the following ROM and strengthening exercises using movement as needed: a. Isometric strengthening of the quadriceps muscle group b. Static stretch of the hamstrings muscle group c. Eccentric biceps brachii curl d. Co...
##### Please answer all parts ing from nanocoulombs to microcoulombs. k here for iled view m Status...
Please answer all parts ing from nanocoulombs to microcoulombs. k here for iled view m Status ▲ 50% Part (a) How many electrons are needed to form a charge of Q/--10 nC? sin0 cotan asin co 4 5 6 atan) acotan0 sinh0 Degrees ORadians I give up! Hints: 0 for a-deduction. Hints remaining: 50%...
##### Discuss the change in potential energy when a molecule is formed from two atoms with the...
Discuss the change in potential energy when a molecule is formed from two atoms with the help of a diagram. Explain the formation of bonding and antibonding molecular orbitals in the hydrogen molecule. What are sp, sp2 and sp3 hybridization? Use carbon-based molecules to explain. Discuss t...
##### Stats LN Online- Spring 18-CRN 22608 Homework: 8.3 HW Score: 0 of 1 pt 8.3.17 Katie...
Stats LN Online- Spring 18-CRN 22608 Homework: 8.3 HW Score: 0 of 1 pt 8.3.17 Katie Hughes & I 3/31/18 11:15 AM Save 7 of 7 (1 complete) ? HYV Score: 142956, 1 of 7 pts Question Help * A company wants to determine whether its consumer product ratings (0-10) have changed from last year to this ye...