Question: Use Excel functions to determine the fixed and variable cost components of repair jobs. Clearly state and label these in your answer. Remember this is

  1. Use Excel functions to determine the fixed and variable cost components of repair jobs.  Clearly state and label these in your answer.  Remember this is an amount of money.

Month

Jobs

Repair costs

January

55

$24,000

February

45

20,000

March

40

19,600

April

50

22,000

May

65

27,000

June

60

25,400

July

35

19,00 0

August

30

15,800

September

25

15,600

October

20

12,600

November

25

17,100

December

30

16,000

Step by Step Solution

★★★★★

3.37 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Variable repair cost ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

60d02c45446d3_219717.pdf

180 KBs PDF File

Word file Icon

60d02c45446d3_219717.docx

120 KBs Word File

Students Have Also Explored These Related Accounting Questions!

Q:

The fixed and variable costs for three potential manufacturing plant sites for a rattan chair weaver are shown: (a) Over what range of production is each location optimal? (b) For a production of 200...

Q:

The fixed and variable costs for three manufacturing plant sites for a product are shown in the following table: a. Over what range of production is each location optimal? b. Which site is best for...

Q:

What are the fixed and variable cost tradeoffs among product, process, and fixed-position layouts? Draw a cost/ volume graph to illustrate your answer.

Q:

The controller of Dugan Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Instructions(a) Determine the fixed and variable cost...

Q:

The controller of Dalton Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Instructions (a) Determine the fixed and variable...

Q:

The controller of Billings Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Instructions (a) Determine the fixed and variable...

Q:

Mikhail Frames Company, which manufactures ornate frames for original art work, began operations in January 2014. Edwin Hyde, the owner, asks for your assistance. He believes that he needs to better...

Q:

Perlman-Douglas, a major retailing and mail-order operation, has been in business for the past 10 years. During that time, the mail-order operations have grown from a sideline to more than 80 percent...

Q:

Lloyd Publications established the following standard price and costs for a hardcover picture book that the company produces. Standard price and variable costs Sales price ................ $45.00...

Q:

Blowing Rock Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by...

Q:

If a firm plans to issue new stock, flotation costs (investment bankers' fees) should not be ignored. There are two approaches to use to account for flotation costs. The first approach is to add the...

Q:

Assessment Task: Prepare a report on diversity management Suppose you are working as a manager in 'Food Fun' restaurant where number of employees are working, belonging to different backgrounds and...

Q:

Management & Leadership : managerial process, empirical, human behaviors (Maslow's hierarchy and McGregor's X & Y theories), social school, quantitative, systems, contingency, trait, power &...

Q:

one busy afternoon, Kit, a barista, received a call from a customer. The customer complained that his drink had a hard, round, white piece of plastic. The customer was mad because he had almost...

Q:

Describe the significance of the following inputs, activities, and outputs to the Architecture Definition Process. Refer to the reading material to provide an educated response. Quote or cite sources...

Q:

Identify the central norms and values you feel characterize the culture in the organization. These factors should be the core values or beliefs that in the experience characterize the way the culture...

Q:

RESTRICTIONS : NO LOOPS , to be done in python 3 . Can use recursion, abstract functions, basic operations 4.2 Intersection Size Write a function intersection_size(L1, L2) which consumes two lists of...

Q:

Shreemaya Hotel in !adore was facing a problem of low demand for its rooms due to off season. The Managing Director (MD) of the hotel, Mrs. Sakina was very worried. She called upon the Marketing...

Q:

What impact does ignoring carrying cost in the allocation of stock in a DRP system have on lot sizes?

Q:

Bill Youngdahl has been collecting data at the TU student grill. He has found that between 5:00 P.M. and 7:00 P.M., students arrive at the grill at a rate of 25 per hour (Poisson distributed) and...

Q:

Assume that the activities in Problem 3.15 have the following costs to shorten: A, $300/week; B, $100/week; C, $200/week; E, $100/week; and F, $400/week. Assume also that you can crash an activity...

Q:

The following data were collected during a study of consumer buying patterns. a. Plot the data as a scatter plot. b. Obtain a linear regression line for the data. (You may use Excels =s lope(Range Y,...

Q:

Two independent set of forecasts based on judgment and experience have been prepared each month for tire past 10 months. The forecasts and actual demand are as follows: a. Calculate tire MSE, MAD,...

Q:

A farming cooperative s manager wants to forecast quarter grain shipments for each quarter of next year (Year 6), based on the data shown below (quantities are in metric tonnes): a. Determine...