Question
In: Accounting
Do in excel please. Sales Budget (Learning Objective 2) Jefferson Sports Medicine, Inc., offers two types...
Do in excel please.
Sales Budget (Learning Objective 2)
Jefferson Sports Medicine, Inc., offers two types of physical exams for students: the basic physical and the extended physical. The charge for the basic physical is $60, while the charge for the extended physical is $135. Jefferson expects to perform 220 basic physicals and 190 extended physicals in July, 235 basic and 200 extended in August, and 105 basic and 110 extended in September. Prepare the sales budget for the service revenue expected from the physical exams performed for the second quarter (July through September), with a column for each month and for the quarter in total.
Solutions
Expert Solution
Solution :
Please find the attached screenshot of the excel sheet containing the detailed calculation for the solution.
ekkarill92 answered 1 year agoRelated Solutions
please show if this is done in excel, Kelson Sporting Equipment, Inc., makes two different types...
please show if this is done in excel,
Kelson Sporting Equipment, Inc., makes two different types of
baseball gloves: a regular model and a catcher’s model. The firm
has 900 hours of production time available in its cutting and
sewing department, 300 hours available in its finishing department,
and 100 hours available in its packaging and shipping department.
The production time requirements and the profit contribution per
glove are given in the following table:
PRODUCTION TIME HOURS
Model
Cutting and...
Please do it by type not pics. Smithson, Inc. produces two types of gas grills: a...
Please do it by type not pics.
Smithson, Inc. produces two types of gas grills: a family model
and a deluxe model. Smithson’s controller has decided to use a
plant-wide overhead rate based on direct labor costs. The president
of the company recently heard of activity-based costing and wants
to see how the results would differ if this system were used. Two
activity cost pools were developed: machining and machine setup.
Presented below is information related to the company’s
operations:...
Please do it by type not pics. Smithson, Inc. produces two types of gas grills: a...
Please do it by type not pics.
Smithson, Inc. produces two types of gas grills: a family model
and a deluxe model. Smithson’s controller has decided to use a
plant-wide overhead rate based on direct labor costs. The president
of the company recently heard of activity-based costing and wants
to see how the results would differ if this system were used. Two
activity cost pools were developed: machining and machine setup.
Presented below is information related to the company’s
operations:...
Sales Mix and Break-Even Sales Dragon Sports Inc. manufactures and sells two products, baseball bats and...
Sales Mix and Break-Even Sales
Dragon Sports Inc. manufactures and sells two products, baseball
bats and baseball gloves. The fixed costs are $318,000, and the
sales mix is 60% bats and 40% gloves. The unit selling price and
the unit variable cost for each product are as follows:
Products
Unit Selling Price
Unit Variable Cost
Bats
$60
$50
Gloves
150
90
a. Compute the break-even sales (units) for the
overall enterprise product, E.
units
b. How many units of each...
Sales mix and break-even sales Dragon Sports Inc. manufactures and sells two products, baseball bats and...
Sales mix and break-even sales
Dragon Sports Inc. manufactures and sells two products, baseball
bats and baseball gloves. The fixed costs are $141,000, and the
sales mix is 80% bats and 20% gloves. The unit selling price and
the unit variable cost for each product are as follows:
Products
Unit Selling Price
Unit Variable Cost
Bats
$60
$60
Gloves
100
50
This information has been collected in the Microsoft Excel
Online file. Open the spreadsheet, perform the required analysis,
and...
Sales Mix and Break-Even Sales Dragon Sports Inc. manufactures and sells two products, baseball bats and...
Sales Mix and Break-Even Sales
Dragon Sports Inc. manufactures and sells two products, baseball
bats and baseball gloves. The fixed costs are $305,800, and the
sales mix is 60% bats and 40% gloves. The unit selling price and
the unit variable cost for each product are as follows:
Products
Unit Selling Price
Unit Variable Cost
Bats
$40
$30
Gloves
100
60
a. Compute the break-even sales (units) for the
overall enterprise product, E.
units
b. How many units of each...
Sales Mix and Break-Even Sales Dragon Sports Inc. manufactures and sells two products, baseball bats and...
Sales Mix and Break-Even Sales
Dragon Sports Inc. manufactures and sells two products, baseball
bats and baseball gloves. The fixed costs are $510,000, and the
sales mix is 20% bats and 80% gloves. The unit selling price and
the unit variable cost for each product are as follows:
Products
Unit Selling Price
Unit Variable Cost
Bats
$70
$50
Gloves
180
110
a. Compute the break-even sales (units) for the
overall enterprise product, E.
units
b. How many units of each...
PLEASE DO BY HAND AND NOT EXCEL 1.A car dealer believes that average daily sales for...
PLEASE DO BY HAND AND NOT EXCEL
1.A car dealer believes that average daily sales for four
different dealerships in four separate states are equal. A random
sample of days results in the following data on daily sales:
Ohio
New York West
Virginia
Pennsylvania
3
10
3
20
2
0
4
11
6
7
5
8
4
8
2
4
0
14
7...
Can you please do in excel 2. Customers arrive at an ATM at a rate of...
Can you please do in excel
2. Customers arrive at an ATM at a rate of 75 per hour (assume
that the arrival process can bedescribed by a Poisson
Distribution). The average time a customer spends at the machine
(excludingwait time) is 45 seconds (assume exponential service
time).
a) What type of queuing system is this?
b) What is the arrival rate (λ)?
c) What is the service rate (μ)?
d) What is the average amount of time that a...
Please do in excel and show the formula 1)Green Manufacturing, Inc. plans to announce that it...
Please do in excel and show the formula
1)Green Manufacturing, Inc. plans to announce that it will issue
$5 million of perpetual debt and use the proceeds to repurchase
common stock. The bonds will have an 8-percent annual coupon rate.
Green is currently an all-equity firm worth $15 million, with
1,000,000 shares of common stock outstanding. After the sales of
the bonds, Green will maintain the new capital structure
indefinitely. Green currently generates annual pretax earnings of
$3 million. This...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Tidewater Company uses the product cost concept of applying the cost-plus approach to product pricing. The...
- Create 5 short-term plan of technology projects that you can perform outside of an I.T. department...
- Derek plans to retire on his 65th birthday. However, he plans to work part-time until he...
- Toady and Froggy were running a vegan cafe together. The business was having financial difficulties.Betelguese, who...
- 1. The following questions concern Jesse Gelsinger who suffered from partial OTC. a. In the...
- Pittman Company is a small but growing manufacturer of telecommunications equipment. The company has no sales...
- TzeMay was one of the first women engineering students at ABC University. She graduated in 1995...
ADVERTISEMENT