Homework Answers
Greetings of the day !
I recon you are having problems in solving the above question using excel. It's pretty easy actually and I am stating the steps you need to follow to create a scatter diagram.
1.Copy the example worksheet data into a blank excel worksheet
2.Click the Insert tab, and then click Insert Scatter (X, Y) or Bubble Chart.
3.Click Scatter.
Just follow the above instructions and you will manage to answer part 2.
1) Example of overhead costs for a bakery cafe that would behave as a :
a) Variable Cost : Ingredients, supplies, packaging materials
b) Fixed Cost : Purchasing Oven.
c) Step Cost : Rent/Lease. It will increase whenever the owner wishes to expand the business.
d) Mixed Cost : Electricity
3)
Add Answer to:
I'm
supposed to solve this problem using excel but I'm not sure how
to
The manager...
Below is data for eVolvalution, Inc. for volumes of units manufactured and sold and related total...
Below is data for eVolvalution, Inc. for volumes of units manufactured and sold and related total costs for five recent periods. August 860 units $41,340 total costs September 830 units $41,800 total costs October 910 units $43,510 total costs November 920 units $43,100 total costs December 990 units $47.450 total costs Based on this data, estimate the company's (i) variable costs (VCs) per unit and (ii) fixed costs, under each of the following approaches: (a) High-Low Method (b) Scattergraph Method...
please answer all the questions below the problem thank u The assistant is unsure how to...
please answer all the questions below the problem
thank u
The assistant is unsure how to classify the utilities costs in the radiology department, since these costs do not exhibit either strictly variable or strictly fixed cost behaviour. Utilities costs are very high in the department due to a CT scanner that draws a large amount of power and is kept running at all times. The scanner cannot be turned off due to the long warm-up period required for its...
Rients Corporation is a service company that measures its output by the number of customers served....
Rients Corporation is a service company that measures its output
by the number of customers served. The company has provided the
following fixed and variable cost estimates that it uses for
budgeting purposes and the actual results of operations for
October.
A. 600 F
B. 600 U
C. 9400 F
D. 9400 U
Rients Corporation is a service company that measures its output by the number of customers served. The company has provided the following fixed and variable cost estimates...
The assistant is unsure how to classify the utilities costs in the radiology department, since these...
The assistant is unsure how to classify the utilities costs in the radiology department, since these costs do not exhibit either strictly variable or strictly fixed cost behaviour. Utilities costs are very high in the department due to a CT scanner that draws a large amount of power and is kept running at all times. The scanner cannot be turned off due to the long warm-up period required for its use. When the scanner is used to scan a patient,...
Problem #1-15 Points Dave's Dogs sells steamed hot dogs for $2.50 each. The company provided the...
Problem #1-15 Points Dave's Dogs sells steamed hot dogs for $2.50 each. The company provided the following units and total cost data concerning its hotdog sales for the last six months of 2017. Cost Units July $3,020 2,400 August 2,795 2,150 September 3,040 2,300 October 2,700 2,250 November 2,750 2,160 December 3,085 2,340 a. Use the high-low method to estimate fixed and variable costs. b. Estimate total profit in a month when 2,200 hotdogs are sold. c. Based on these...
I'm trying to solve question 4c and 5 I'm a little lost on how to do...
I'm trying to solve question 4c and 5 I'm a little
lost on how to do it
Dozier Company produced and sold 1000 units during its first month of operations. It reported the following costs and expenses for the month: $ 83, Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Total manufacturing overhead Variable selling expense Fixed selline expense Total selling expense Variable inistrative expense Fixed adninistrative expense Total administrative expense $ 20, 32,20 $32.880 $14, see 23,60e...
i been trying a lot but i dont know how to calculate Maria Chavez owns a...
i been trying a lot but i dont know how to
calculate
Maria Chavez owns a catering company that serves food and beverages at parties and business functions. Chavez's business is seasonal, with a heavy schedule during the summer months and holidays and a lighter schedule at other times. One of the major events Chavez's customers request is a cocktail party. She offers a standard cocktail party and has estimated the cost per guest as follows: Food and beverages Labor...
Korsak Corporation is a service company that measures its output by the number of customers served....
Korsak Corporation is a service company that measures its output by the number of customers served. The company has provided the following fixed and variable cost estimates that it uses for budgeting purposes. Fised Element Variable Element per per Month Customer Served Revenue 5,500 Employee salaries and 43,700 $ 1,100 wages Travel expenses $ 500 Other expenses $ 43,200 The planning budget for October was based on serving 23 customers, but a total of 19 customers were actually served during...
Problem 4-4 Lancer Audio produces a high-end DVD player that sells for $1,300. Total operating expenses...
Problem 4-4 Lancer Audio produces a high-end DVD player that sells for $1,300. Total operating expenses for July were as follows: 150 $71,000 2,500 25,000 2,300 5,600 Units produced and sold Component costs Supplies Assembly labor Rent Supervisor salary Electricity Telephone Gas Shipping Advertising Administrative costs Total 350 280 300 2,000 2,600 15,000 $126,930 Total operating expenses for the past 12 months are as follows: August September October November December January February March April Units Produced and Sold 165 130...
Required information (The following information applies to the questions displayed below.) Adger Corporation is a service...
Required information (The following information applies to the questions displayed below.) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element Variable Element per per Customer Month Served $ 5,800 $ 54,000 $ 1,500 $ 800 $ 33,000 Revenue Employee salaries and wages Travel expenses Other...
Below is data for eVolvalution, Inc. for volumes of units manufactured and sold and related total costs for five recent periods. August 860 units $41,340 total costs September 830 units $41,800 total costs October 910 units $43,510 total costs November 920 units $43,100 total costs December 990 units $47.450 total costs Based on this data, estimate the company's (i) variable costs (VCs) per unit and (ii) fixed costs, under each of the following approaches: (a) High-Low Method (b) Scattergraph Method...
please answer all the questions below the problem
thank u
The assistant is unsure how to classify the utilities costs in the radiology department, since these costs do not exhibit either strictly variable or strictly fixed cost behaviour. Utilities costs are very high in the department due to a CT scanner that draws a large amount of power and is kept running at all times. The scanner cannot be turned off due to the long warm-up period required for its...
Rients Corporation is a service company that measures its output
by the number of customers served. The company has provided the
following fixed and variable cost estimates that it uses for
budgeting purposes and the actual results of operations for
October.
A. 600 F
B. 600 U
C. 9400 F
D. 9400 U
Rients Corporation is a service company that measures its output by the number of customers served. The company has provided the following fixed and variable cost estimates...
The assistant is unsure how to classify the utilities costs in the radiology department, since these costs do not exhibit either strictly variable or strictly fixed cost behaviour. Utilities costs are very high in the department due to a CT scanner that draws a large amount of power and is kept running at all times. The scanner cannot be turned off due to the long warm-up period required for its use. When the scanner is used to scan a patient,...
Problem #1-15 Points Dave's Dogs sells steamed hot dogs for $2.50 each. The company provided the following units and total cost data concerning its hotdog sales for the last six months of 2017. Cost Units July $3,020 2,400 August 2,795 2,150 September 3,040 2,300 October 2,700 2,250 November 2,750 2,160 December 3,085 2,340 a. Use the high-low method to estimate fixed and variable costs. b. Estimate total profit in a month when 2,200 hotdogs are sold. c. Based on these...
I'm trying to solve question 4c and 5 I'm a little
lost on how to do it
Dozier Company produced and sold 1000 units during its first month of operations. It reported the following costs and expenses for the month: $ 83, Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Total manufacturing overhead Variable selling expense Fixed selline expense Total selling expense Variable inistrative expense Fixed adninistrative expense Total administrative expense $ 20, 32,20 $32.880 $14, see 23,60e...
i been trying a lot but i dont know how to
calculate
Maria Chavez owns a catering company that serves food and beverages at parties and business functions. Chavez's business is seasonal, with a heavy schedule during the summer months and holidays and a lighter schedule at other times. One of the major events Chavez's customers request is a cocktail party. She offers a standard cocktail party and has estimated the cost per guest as follows: Food and beverages Labor...
Korsak Corporation is a service company that measures its output by the number of customers served. The company has provided the following fixed and variable cost estimates that it uses for budgeting purposes. Fised Element Variable Element per per Month Customer Served Revenue 5,500 Employee salaries and 43,700 $ 1,100 wages Travel expenses $ 500 Other expenses $ 43,200 The planning budget for October was based on serving 23 customers, but a total of 19 customers were actually served during...
Problem 4-4 Lancer Audio produces a high-end DVD player that sells for $1,300. Total operating expenses for July were as follows: 150 $71,000 2,500 25,000 2,300 5,600 Units produced and sold Component costs Supplies Assembly labor Rent Supervisor salary Electricity Telephone Gas Shipping Advertising Administrative costs Total 350 280 300 2,000 2,600 15,000 $126,930 Total operating expenses for the past 12 months are as follows: August September October November December January February March April Units Produced and Sold 165 130...
Required information (The following information applies to the questions displayed below.) Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Fixed Element Variable Element per per Customer Month Served $ 5,800 $ 54,000 $ 1,500 $ 800 $ 33,000 Revenue Employee salaries and wages Travel expenses Other...
Most questions answered within 3 hours.
-
Assume a binomial probability distribution with n=40 and π=0.26.
Compute the following:
A.) The Mean and...
asked 1 minute ago -
A 2.1-cm-tall object is 19.2 cm to the left of a lens with focal
length of...
asked 3 minutes ago -
In
EXCEL VBA:
How would I manage to do this in VBA?
The assignment is in...
asked 18 minutes ago -
what is the statistical probability of 2 caucasians
having identical STR profiles
asked 15 minutes ago -
A wheel with a radius of 0.5m starts to rotate from rest and
reaches full speed...
asked 21 minutes ago -
Why are short bones well suited to an area like the wrist? Why
are long bones...
asked 32 minutes ago -
A uniform disk with mass m = 9.04 kg and radius R = 1.35 m lies...
asked 36 minutes ago -
Two dogs pull horizontally on ropes attached to a
post; the angle between the ropes is...
asked 51 minutes ago -
You are still fascinated by the process of inkjet printing, as
described in the opening storyline...
asked 49 minutes ago -
How do employees evaluate the fairness of an authority's
decision making?
asked 35 minutes ago -
What can we observe during the cake filtration of
suspensions?
asked 44 minutes ago -
What does the grounding mean especially at EMI point of
view?
asked 50 minutes ago