Excel Project 2 IFSM
.xlsx
keyboard_arrow_up
School
University of Maryland, University College *
*We aren’t endorsed by this school
Course
201
Subject
Finance
Date
Feb 20, 2024
Type
xlsx
Pages
12
Uploaded by Shegetsanswers101
Name:
STUDENT NAME
Class/Section:
IFSM 201/6373
Project:
Excel Project #2
Date Due:
21-Sep-21
Year
Quarter
Location
CarClass
Revenue
NumCars
2018
Q2
Airport
Premium
$303,242 1,933
2018
Q2
Airport
Hybrid
$303,607 1,982
2018
Q2
Airport
SUV
$303,199
2,027
2018
Q1
Airport
Premium
$359,382
2,335
2018
Q1
Downtown
Premium
$354,474
2,383
2018
Q1
Airport
Hybrid
$359,794
2,401
2018
Q1
Downtown
Hybrid
$354,745
2,420
2018
Q1
Airport
SUV
$360,039
2,488
2018
Q1
Downtown
SUV
$354,839
2,512
2018
Q1
Downtown
Economy
$358,719
2,711
2018
Q2
Downtown
Economy
$379,501
2,742
2018
Q3
Airport
Premium
$483,322
3,004
2018
Q3
Airport
Hybrid
$483,684
3,090
2018
Q2
Downtown
Premium
$466,323
3,095
2018
Q2
Downtown
Hybrid
$466,712
3,133
2018
Q3
Airport
SUV
$482,829
3,201
2018
Q1
Airport
Economy
$449,582
3,260
2018
Q2
Downtown
SUV
$466,527
3,277
2018
Q2
Airport
Economy
$480,589
3,337
2018
Q3
Downtown
Premium
$516,616
3,381
2018
Q3
Downtown
Hybrid
$516,779
3,444
2018
Q4
Downtown
Economy
$508,821
3,457
2018
Q3
Downtown
SUV
$517,006
3,603
2018
Q4
Downtown
Premium
$596,796
3,856
2018
Q4
Airport
Premium
$634,905
3,892
2018
Q4
Downtown
Hybrid
$596,477
3,946
2018
Q4
Airport
Hybrid
$634,492
3,976
2018
Q4
Downtown
SUV
$596,103
4,098
2018
Q4
Airport
Economy
$612,501
4,112
2018
Q4
Airport
SUV
$617,852
4,115
2018
Q3
Airport
Economy
$701,974
4,742
2018
Q3
Downtown
Economy
$770,161
5,386
2019
Q2
Airport
Economy
$368,286
2,153
2019
Q4
Downtown
Premium
$431,761
2,562
2019
Q4
Downtown
Hybrid
$431,140
2,620
2019
Q1
Downtown
Premium
$424,833
2,661
2019
Q4
Downtown
SUV
$431,029
2,708
2019
Q1
Downtown
Hybrid
$425,127
2,729
2019
Q1
Downtown
SUV
$424,718
2,799
2019
Q3
Downtown
Premium
$494,587
3,006
2019
Q3
Downtown
Hybrid
$494,669
3,065
2019
Q4
Airport
Premium
$540,411
3,082
2019
Q2
Downtown
Premium
$500,347
3,101
2019
Q4
Airport
Hybrid
$541,112
3,115
2019
Q2
Downtown
Hybrid
$500,601
3,172
2019
Q3
Downtown
SUV
$495,372
3,197
2019
Q4
Airport
SUV
$540,599
3,231
2019
Q2
Downtown
SUV
$500,494
3,251
2019
Q1
Airport
Economy
$499,117
3,296
2019
Q1
Airport
Premium
$565,965
3,418
2019
Q1
Airport
Hybrid
$565,721
3,515
2019
Q3
Airport
Economy
$593,981
3,555
2019
Q2
Airport
Premium
$599,690
3,556
2019
Q1
Airport
SUV
$565,749
3,623
2019
Q2
Airport
Hybrid
$599,005
3,650
2019
Q2
Airport
SUV
$599,382
3,783
2019
Q3
Airport
Premium
$658,374
3,883
2019
Q3
Airport
Hybrid
$658,702
3,927
2019
Q3
Airport
SUV
$658,241
4,097
2019
Q2
Downtown
Economy
$641,168
4,302
2019
Q3
Downtown
Economy
$681,155
4,540
2019
Q4
Downtown
Economy
$704,556
4,620
2019
Q1
Downtown
Economy
$718,651
4,898
2019
Q4
Airport
Economy
$918,045
5,224
Year
Quarter
Location
CarClass
Revenue
NumCars
2018
Q2
Airport
Premium
$303,242 1,933
2018
Q2
Airport
Hybrid
$303,607 1,982
2018
Q2
Airport
SUV
$303,199
2,027
2018
Q1
Airport
Premium
$359,382
2,335
2018
Q1
Downtown
Premium
$354,474
2,383
2018
Q1
Airport
Hybrid
$359,794
2,401
2018
Q1
Downtown
Hybrid
$354,745
2,420
2018
Q1
Airport
SUV
$360,039
2,488
2018
Q1
Downtown
SUV
$354,839
2,512
2018
Q1
Downtown
Economy
$358,719
2,711
2018
Q2
Downtown
Economy
$379,501
2,742
2018
Q3
Airport
Premium
$483,322
3,004
2018
Q3
Airport
Hybrid
$483,684
3,090
2018
Q2
Downtown
Premium
$466,323
3,095
2018
Q2
Downtown
Hybrid
$466,712
3,133
2018
Q3
Airport
SUV
$482,829
3,201
2018
Q1
Airport
Economy
$449,582
3,260
2018
Q2
Downtown
SUV
$466,527
3,277
2018
Q2
Airport
Economy
$480,589
3,337
2018
Q3
Downtown
Premium
$516,616
3,381
2018
Q3
Downtown
Hybrid
$516,779
3,444
2018
Q4
Downtown
Economy
$508,821
3,457
2018
Q3
Downtown
SUV
$517,006
3,603
2018
Q4
Downtown
Premium
$596,796
3,856
2018
Q4
Airport
Premium
$634,905
3,892
2018
Q4
Downtown
Hybrid
$596,477
3,946
2018
Q4
Airport
Hybrid
$634,492
3,976
2018
Q4
Downtown
SUV
$596,103
4,098
2018
Q4
Airport
Economy
$612,501
4,112
2018
Q4
Airport
SUV
$617,852
4,115
2018
Q3
Airport
Economy
$701,974
4,742
2018
Q3
Downtown
Economy
$770,161
5,386
2019
Q2
Airport
Economy
$368,286
2,153
2019
Q4
Downtown
Premium
$431,761
2,562
2019
Q4
Downtown
Hybrid
$431,140
2,620
2019
Q1
Downtown
Premium
$424,833
2,661
2019
Q4
Downtown
SUV
$431,029
2,708
2019
Q1
Downtown
Hybrid
$425,127
2,729
2019
Q1
Downtown
SUV
$424,718
2,799
2019
Q3
Downtown
Premium
$494,587
3,006
2019
Q3
Downtown
Hybrid
$494,669
3,065
2019
Q4
Airport
Premium
$540,411
3,082
2019
Q2
Downtown
Premium
$500,347
3,101
2019
Q4
Airport
Hybrid
$541,112
3,115
2019
Q2
Downtown
Hybrid
$500,601
3,172
2019
Q3
Downtown
SUV
$495,372
3,197
2019
Q4
Airport
SUV
$540,599
3,231
2019
Q2
Downtown
SUV
$500,494
3,251
2019
Q1
Airport
Economy
$499,117
3,296
2019
Q1
Airport
Premium
$565,965
3,418
2019
Q1
Airport
Hybrid
$565,721
3,515
2019
Q3
Airport
Economy
$593,981
3,555
2019
Q2
Airport
Premium
$599,690
3,556
2019
Q1
Airport
SUV
$565,749
3,623
2019
Q2
Airport
Hybrid
$599,005
3,650
2019
Q2
Airport
SUV
$599,382
3,783
2019
Q3
Airport
Premium
$658,374
3,883
2019
Q3
Airport
Hybrid
$658,702
3,927
2019
Q3
Airport
SUV
$658,241
4,097
2019
Q2
Downtown
Economy
$641,168
4,302
2019
Q3
Downtown
Economy
$681,155
4,540
2019
Q4
Downtown
Economy
$704,556
4,620
2019
Q1
Downtown
Economy
$718,651
4,898
2019
Q4
Airport
Economy
$918,045
5,224
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
P
00
it View
History
Bookmarks
Window
Help
00
A ezto.mheducation.com
nt Portal
Course Modules: Budgeting and Forecasting 62211
Week 4: Homework
Question 3 - Week 4: Homework - Co
omework G
Saved
Help
Save & Exit
Submit
Check my work
Information pertaining to Noskey Corporation's sales revenue follows:
November 2021
(Actual)
$ 180,000
December 2021
(Budgeted)
$ 160,000
500,000
January 2022
(Budgeted)
Cash sales
000'09
$ 540,000
Credit sales
$ 360,000
000'09
Total sales
000'099 2$
Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the
remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next month's projected
total sales (stated at cost) plus 30% of projected sales for the current month (stated at cost). All inventory purchases are on-account;
25% is paid in the month of purchase, and the remainder is paid in the month following the month of purchase.…
arrow_forward
Online Test Window-Google Chrome
tests.mettl.com/test-window/f55ac827#/testWindow/0/6/1
EY
Accounting Assessment
Total 00:55.46
Finish Test
Section 1 of 1 Section #1 v
12
5.
7
8.
6.
10
11
7 of 45
All
2
43
Question #7
GRevisit
Choose the best option
Wages paid to own employees who have redecorated the office are
O capital expenditure.
debited to profit and loss account.
debited to premises account.,
O credited to profit and loss account.
Frev Question
Next Question
+91-82878-03040
Zaineh | Support +1-650-924-9221
4:12 PM
metti
1/16/2021
arrow_forward
Help please with right answer
arrow_forward
Solutions only thank you
arrow_forward
W NWP Assessment Player UI Application
W NWP Assessment
- 1023.121103 BFN-C201-1023-...
th Solution Walkthrough Videos
Question 3 of 7
-/0.75
View Policies
Current Attempt in Progress
You are trying to choose between purchasing one of two machines for a factory. Machine A costs $15,400 to purchase and has a
three-year life. Machine B costs $17,500 to purchase but has a four year life. Regardless of which machine you purchase, it will have
to be replaced at the end of its operating life. Assume a marginal tax rate of 35 percent and a discount rate of 13 percent.
Calculate the equivalent annual costs (EAC) of each machines. (Do not round intermediate calculations. Round answers to 2
decimal places, e.g. 15.27.)
Equivalent Annual Cost (EAC) of machine A
$4
Equivalent Annual Cost (EAC) of machine B
$4
Which machine should you choose?
You should choose
eTextbook and Media
Save for Later
Attempts: 0 of 3 used
Submit Answer
arrow_forward
FINAL EXAM Managerial Finance.pdf - Adobe Reader
File Edit View Window Help
Оpen
1
73.8%
Tools
Fill & Sign Comme
Sign I
• Export PDF
• Create PDF
• Edit PDF
1- Evaluate the following projects using the payback method assuming a rule of 3
for payback.
years
• Combine PDF
Project A
-10,000
Project B
-10,000
Year
• Send Files
1
4,000
4,000
Store Files
Full-screen Snip
4,000
3,000
3
4,000
2,000
Acrobat.com
4
1,000,000
arrow_forward
Sserg_lall20 / Midterm Exam One_FALL2020 / Exam 1_Part 2
- 10
Company XYZ produces computer laptops. During July 2019, the company produced 1,000
laptops. The company incurred OMR4,000 direct materials, OMR20,000 direct labor,
OMR35,000 variable manufacturing overhead, OMR2,000 fixed manufacturing overhead and
OMR15,000 total selling and administrative expenses. Calculate the manufacturing cost per
unit for the month of July.
out of
question
Select one:
O a. OMR61
O b. OMR37
C. OMR76
O d. OMR59
O e. OMR24
Fi
11
Company XYZ has raw materials at the beginning of August of OMR150,000. During August,
the company purchased additional raw materials of OMR30,000. During August also, the
company used OMR120,000 raw materials; OMR100,000 directly on the production process
and OMR20,000 related to maintenance of administrative cars. How much balance in the raw
put of
materials by the end of August?
juestion
18
arrow_forward
Photo from XYZ
arrow_forward
Course: 2020FA Accounting for X
* CengageNOWv2 | Online teachir x
/v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAs...
еВook
GE Calculator
Sales Mix and Break-Even Sales
Data related to the expected sales of kayaks and canoes for River Sports Inc. for the current year, which is typical of recent years, are as
follows:
Products Unit Selling Price Unit Variable Cost Sales Mix
Kayaks
$240
$160
20%
Canoes
510
240
80%
The estimated fixed costs for the current year are $273,760.
Instructions:
1. Determine the estimated units of sales of the overall product necessary to reach the break-even point for the current year.
units
2. Based on the break-even sales (units) in part (1), determine the unit sales of both kayaks and canoes for the current year.
Kayaks
units
Canoes
units
3. Assume that the sales mix was 80% Kayaks and 20% canoes. Determine the estimated units of sales of the overall product necessary
to reach the break-even point for the current year.
units
田
arrow_forward
Unauthorized
My Home
CengageNOWv2 | Online teachin ×
+
https://v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogres.
Chapter 20
еBook
Show Me How
Contribution Margin Ratio
a. Young Company budgets sales of $112,900,000, fixed costs of $25,000,000, and variable costs of $66,611,000. What is the contribution margin ratio for Young Company?
%
b. If the contribution margin ratio for Martinez Company is 40%, sales were $34,800,000, and fixed costs were $1,500,000, what was the operating income?
$4
6:39 PM
63°F
11/5/2021
arrow_forward
The actual and planned data for Underwater University for the Fall term were as follows:
Actual
Planned
Enrollment
4,500
4,125
Tuition per credit hour
$120
$135
Credit hours
60,450
43,200
Registration, records, and marketing costs per enrolled student
$275
$275
Instructional costs per credit hour
$64
$60
Depreciation on classrooms and equipment
$825,600
$825,600
Registration, records, and marketing costs vary by the number of enrolled students, while instructional costs vary by the number of credit hours. Depreciation is a fixed cost.
Prepare a variable costing income statement showing the contribution margin and operating income for the Fall term.
Underwater University
Variable Costing Income Statement
For the Fall Term
Revenue
$
Variable costs:
Registration, records, and marketing costs
$
Instructional costs
Total variable costs
$
Contribution margin
$
Depreciation on classrooms and equipment
Operating income…
arrow_forward
Suffolk County Communlty
uny.edu/webapps/assessment/take/launch.jsp?course_assessment_id
Question Completion Status:
Quantity of
Earbuds
Quantity of
Earbuds
Price
Supplied
per Month
9000
Demanded
per
Earbud
per Month
500
$20
18
1000
6000
16
1500
4500
14
2000
3500
12
2500
2500
10
3000
1500
3500
800
6.
4000
100
According to the above table, at a price of $16 per earbud, there is
a shortage of 1500 earbuds.
a shortage of 3000 earbuds.
a surplus of 3000 earbuds.
an equilibrium.
QUESTION 14
Price per
Quantity of
XDemanded
Quantity of
X Supplied
per Time Peri od
150
Constant
Quality of X
$10
per Time Peri od
120
arrow_forward
Need both questions
arrow_forward
Can you help me find the blanks
arrow_forward
PART I
Brave Heart Hospital showed the following major hospital costs at various levels of activity for CY 2020:
Month
Hospital Admission Major Hospital Cost(P)
February
1,300
P850,000.00
March
8,500
P1,350,000.00
April
1,600
P1,150,000.00
May
1,400
P950,000.00
June
1,200
P800,000.00
July
200
P50,000.00
August
1,650
P1,200,000.00
September
1,550
P1,050,000.00
The breakdown of the major hospital costs in the month of May at 1,400 hospital admission is as follows:
Accommodation Expense (Variable)
P400,000.00
Utilities (Fixed)
P300,000.00
Medicine (Mixed)
P250,000.00
Total Overhead Cost
P950,000.00
Requirements:
1. Determine how much of major hospital cost for the month of August of P1,200,000.00 consisted of medicine
cost
2. Using high-low method, determine the cost function for Medicine
3. Using high-low method, determine the cost function for major hospital cost
4. What would be the total major hospital cost if hospital admission is at 2,000?
arrow_forward
7/26/2021
Content
The hospital where you are employed is continuing with their analysis with the goal of opening a walk-
in clinic. After conducting additional research, the financial projections for the first year of operations
are as follows:
• Revenues (from 10,000 visits): $400,000
Wages and benefits: $220,000
• Rent: $5,000
Depreciation: $30,000
Utilities: $2,500
• Medical supplies: $50,000
Administrative supplies: $10,000
Assume that all costs are fixed except supply costs, which are variable. Assume that the clinic will be
required to pay taxes at a 30% tax rate. Respond to the following questions. Be sure to show your
work for all calculations.
1. Prepare the clinic's projected Profit and Loss (P&L) Statement. (8 points)
2. What number of visits is required to break even? (3 points)
3. What number of visits is required to provide you with an after-tax profit of $100,000? (4 points)
arrow_forward
&external_browser%3D0&launchUrl=https%253A%252F%252Fnewconnect.mheducation.com%252F#/activity/question-group
ter 8 homework i
Saved
Help
Save & Exit
Sub
Check my wor
Samuelson and Messenger (SAM) began 2021 with 200 units of its one product. These units were purchased near the end of 2020 for
$25 each. During the month of January, 100 units were purchased on January 8 for $28 each and another 200 units were purchased
on January 19 for $30 each. Sales of 125 units and 100 units were made on January 10 and January 25, respectively. There were 275
units on hand at the end of the month. SAM uses a periodic inventory system.
Required:
1. Calculate ending inventory and cost of goods sold for January using FIFO.
2. Calculate ending inventory and cost of goods sold for January using average cost.
oped
Complete this question by entering your answers in the tabs below.
ook
Required 1
Required 2
rint
Calculate ending inventory and cost of goods sold for January using FIFO.
rences
Cost of Goods…
arrow_forward
FunTime Cruiseline offers nightly dinner cruises departing from several cities on the east-
ern coast of the United States including Charleston, Baltimore, and Alexandria. Dinner
cruise tickets sell for $50 per passenger. FunTime Cruiseline's variable cost of providing
the dinner is $30 per passenger, and the fixed cost of operating the vessels (depreciation,
salaries, docking fees, and other expenses) is $210,000 per month. The company's rel-
evant range extends to 20,000 monthly passengers.
arrow_forward
A https://camdenccinstructure.com/courses/3788/assignmen *
QuestionTO
ces
View Policies
ions
Current Attempt in Progress
5 Support
The master budget of Waterway Industries shows that the
planned activity level for next year is expected to be 50000
machine hours. At this level of activity, the following
manufacturing overhead costs are expected:
al
Indirect labor
$820000
Machine supplies
280000
Indirect materials
310000
Depreciation on factory building
250000
Total manufacturing overhead
$1660000
A flexible budget for a level of activity of 60000 machine
hours would show total manufacturing overhead costs of
$1942000.
O $1992000.
O $1742000.
$1660000.
arrow_forward
Relevant Cost Irrelevant Cost
or Benefit
Opportunity
Cost
Sunk Cost
or Benefit
$40,000 salary from Shelton
Anticipated $48,000 salary with an accounting degree
Tuition and books for years 1-3 of college
Cost to relocate to Seattle
Tuition and books for remaining two semesters
$19,000 from your part-time job, which you plan to keep until
you graduate
Cost to rent an apartment in Seattle (assume you are currently
living at home with your parents)
Food and entertainment expenses, which are expected to be
the same in Seattle as where you currently live
Increased promotional opportunities that will come from having
a college degree
arrow_forward
I
+ %06
| +
Business started off great the first year that the Golden Wolves Statues started production. Corey
realized, however, that the business was seasonal and had peak sales in the fall, during the third
quarter, when the students started college and continued through the beginning of the football
season. The following information concerns operations for Year 2, the coming year, and for the
first two quarters of Year 3.
A. Golden Wolves Statue Company is now making only the forward-facing statue with the
Alvernia University t-shirt and sells the product for $150/unit. Budgeted unit sales for the
next six quarters are as follows (all sales are on credit).
Year 2 Quarter
Year 3 Quarter
3
4
2.
Budgeted unit sales
680
000
009
B. Sales are collected in the following pattern: 75% in the quarter the sales are made, and the
remaining 25% in the following quarter. On January 1, Year 2, the company's balance sheet
shows $6,500 in accounts receivable, all of which will be collected in the…
arrow_forward
aj.3
arrow_forward
CengageNOWv2| Online teachin X
N2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=D&inpro...
Differential Analysis Involving Opportunity Costs
On July 1, Coastal Distribution Company is considering leasing a building and buying the necessary equipment to operate a public w
Alternatively, the company could use the funds to invest in $149,100 of 6% U.S. Treasury bonds that mature in 16 years. The bond
at face value. The following data have been assembled:
Cost of store equipment
$149,100
Life of store equipment
16 years
Estimated residual value of store equipment
$18,600
Yearly costs to operate the warehouse, excluding
depreciation of equipment
$55,900
Yearly expected revenues-years 1-8
75,600
Yearly expected revenues-years 9-16
70,100
Required:
1. Prepare a differential analysis as of July 1 presenting the proposed operation of the warehouse for the 16 years (Alternative 1) a
investing in U.S. Treasury bonds (Alternative 2). If an amount is…
arrow_forward
Assignment 6.1: Session 6 Comprehensive Problem (Chapter 8)
Instructions
In this session, we have a 6-part comprehensive problem. Download the Session 6 Comprehensive Problem Templates below to complete the 6 required parts of the problem. You will need your Bergevin and MacQueen book for reference.
Rancho Cucamonga Inc. began business on January 1, 2020. The firm earned $100 from sales in its first year of business. Rancho Cucamonga collected $90 of revenue earned in cash during 2020 and reported a $10 account receivable on its 2020 balance sheet. The firm paid $70 cash for operating expenses in 2020 and reported a $5 account payable for unpaid operating expenses on its 2020 balance sheet. Income tax laws only recognize cash collected from sales and cash paid for expenses as taxable items in the year collected or paid.
Rancho Cucamonga also reported a $10 fine, paid in cash, to the federal government for unfair business practices. Generally accepted accounting principles allow firms…
arrow_forward
Don't give answer in image
arrow_forward
QUESTION 38
Last month, Jeff applied to three colleges (X, Y, and Z). Before applying he and his family had visited the all three colleges. Jeff has received admissions from Colleges X and Y. He is trying to decide which college he will attend. The following information is available:
College X College Y
(1) Cost of attendance $30,000 $21,000
(2) Program quality Excellent Average
(3) Campus visit cost $900 $300
(4) Location big city big city
(5) Scholarship $10,000 $10,000
Select the items that are relevant to Jeff's decision.
A.
(2), (4) only
B.
(1), (2), (3) only
C.
(1), (2) only
D.
(1), (3), (5) only
E.
(1), (3) only
arrow_forward
Help please
arrow_forward
- Main View | Course X
* CengageNOWV2| Online teachin X
University of Sioux Falls, South D x -
genow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator%3D&inpro...
eBook
Average Rate of Return-Cost Savings
Maui Fabricators Inc. is considering an investment in equipment that will replace direct labor. The equipment has a cost of $90,000 with a $8,000
residual value and a ten-year life. The equipment will replace one employee who has an average wage of $15,980 per year. In addition, the equipment
will have operating and energy costs of $4,350 per year.
Determine the average rate of return on the equipment, giving effect to straight-line depreciation on the investment. If required, round to the nearest
whole percent.
IC
arrow_forward
Help please
arrow_forward
Please do not give solution in image format thanku
arrow_forward
yout References Mailings Review View
A A Aa AEE-FE
x² A--A- ES
ht
09
1
Paragraph
2
1
1
Total Cost
1
No of Guests
Jo
P¶¶4 21
LT
Direct Costs
Selling overhead
Administration overhead
Document1 Word
Help
Y
17
The Aldorf Wastoria.
The Financial Manager of Aldorf Wastoria has prepared the following flexed budget
for 2023. The Aldorf is a large hotel, which can provide up to a maximum of 22,000
guest nights per year.
Acrobat
Tell me what you want to do
AaBbCcDc AaBbCcDc AaBbCc AaBbcct AaE B
1 Normal
1 No Spac... Heading 1
Heading 2
Title
15,400
£
[W]
231,000
264,000
1,318,800 1,338,600
900,000
900,000
Capacity
17,600
£
11
8
Styles
5
2,449,800 2,502,600 2,555,400
Due to the recent poor weather, the Sales Manager has suggested that 15,000
guests is a more realistic target for 2023. Based on this, what are the expected total
costs for 2023?
19,800
£
297,000
1,358,400
900,000
6
→
pri sc
36°C Mostly
arrow_forward
please help me
arrow_forward
Help please
arrow_forward
Helppp
arrow_forward
dy Home
CengageNOWv2| Online teachin x
/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
Xander Studios holds a sculpting class for which it charges students $250. The costs consist of the following:
Variable costs per student:
Sculpting supplies
$100
Enrollment costs
50
Fixed costs for the course:
Instructor's salary
$1,000
Rental cost of the classroom
500
The break-even number of students is
Oa. 2
ОБ. 12
Oc. 20
Od. 11
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- P 00 it View History Bookmarks Window Help 00 A ezto.mheducation.com nt Portal Course Modules: Budgeting and Forecasting 62211 Week 4: Homework Question 3 - Week 4: Homework - Co omework G Saved Help Save & Exit Submit Check my work Information pertaining to Noskey Corporation's sales revenue follows: November 2021 (Actual) $ 180,000 December 2021 (Budgeted) $ 160,000 500,000 January 2022 (Budgeted) Cash sales 000'09 $ 540,000 Credit sales $ 360,000 000'09 Total sales 000'099 2$ Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next month's projected total sales (stated at cost) plus 30% of projected sales for the current month (stated at cost). All inventory purchases are on-account; 25% is paid in the month of purchase, and the remainder is paid in the month following the month of purchase.…arrow_forwardOnline Test Window-Google Chrome tests.mettl.com/test-window/f55ac827#/testWindow/0/6/1 EY Accounting Assessment Total 00:55.46 Finish Test Section 1 of 1 Section #1 v 12 5. 7 8. 6. 10 11 7 of 45 All 2 43 Question #7 GRevisit Choose the best option Wages paid to own employees who have redecorated the office are O capital expenditure. debited to profit and loss account. debited to premises account., O credited to profit and loss account. Frev Question Next Question +91-82878-03040 Zaineh | Support +1-650-924-9221 4:12 PM metti 1/16/2021arrow_forwardHelp please with right answerarrow_forward
- Solutions only thank youarrow_forwardW NWP Assessment Player UI Application W NWP Assessment - 1023.121103 BFN-C201-1023-... th Solution Walkthrough Videos Question 3 of 7 -/0.75 View Policies Current Attempt in Progress You are trying to choose between purchasing one of two machines for a factory. Machine A costs $15,400 to purchase and has a three-year life. Machine B costs $17,500 to purchase but has a four year life. Regardless of which machine you purchase, it will have to be replaced at the end of its operating life. Assume a marginal tax rate of 35 percent and a discount rate of 13 percent. Calculate the equivalent annual costs (EAC) of each machines. (Do not round intermediate calculations. Round answers to 2 decimal places, e.g. 15.27.) Equivalent Annual Cost (EAC) of machine A $4 Equivalent Annual Cost (EAC) of machine B $4 Which machine should you choose? You should choose eTextbook and Media Save for Later Attempts: 0 of 3 used Submit Answerarrow_forwardFINAL EXAM Managerial Finance.pdf - Adobe Reader File Edit View Window Help Оpen 1 73.8% Tools Fill & Sign Comme Sign I • Export PDF • Create PDF • Edit PDF 1- Evaluate the following projects using the payback method assuming a rule of 3 for payback. years • Combine PDF Project A -10,000 Project B -10,000 Year • Send Files 1 4,000 4,000 Store Files Full-screen Snip 4,000 3,000 3 4,000 2,000 Acrobat.com 4 1,000,000arrow_forward
- Sserg_lall20 / Midterm Exam One_FALL2020 / Exam 1_Part 2 - 10 Company XYZ produces computer laptops. During July 2019, the company produced 1,000 laptops. The company incurred OMR4,000 direct materials, OMR20,000 direct labor, OMR35,000 variable manufacturing overhead, OMR2,000 fixed manufacturing overhead and OMR15,000 total selling and administrative expenses. Calculate the manufacturing cost per unit for the month of July. out of question Select one: O a. OMR61 O b. OMR37 C. OMR76 O d. OMR59 O e. OMR24 Fi 11 Company XYZ has raw materials at the beginning of August of OMR150,000. During August, the company purchased additional raw materials of OMR30,000. During August also, the company used OMR120,000 raw materials; OMR100,000 directly on the production process and OMR20,000 related to maintenance of administrative cars. How much balance in the raw put of materials by the end of August? juestion 18arrow_forwardPhoto from XYZarrow_forwardCourse: 2020FA Accounting for X * CengageNOWv2 | Online teachir x /v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAs... еВook GE Calculator Sales Mix and Break-Even Sales Data related to the expected sales of kayaks and canoes for River Sports Inc. for the current year, which is typical of recent years, are as follows: Products Unit Selling Price Unit Variable Cost Sales Mix Kayaks $240 $160 20% Canoes 510 240 80% The estimated fixed costs for the current year are $273,760. Instructions: 1. Determine the estimated units of sales of the overall product necessary to reach the break-even point for the current year. units 2. Based on the break-even sales (units) in part (1), determine the unit sales of both kayaks and canoes for the current year. Kayaks units Canoes units 3. Assume that the sales mix was 80% Kayaks and 20% canoes. Determine the estimated units of sales of the overall product necessary to reach the break-even point for the current year. units 田arrow_forward
- Unauthorized My Home CengageNOWv2 | Online teachin × + https://v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogres. Chapter 20 еBook Show Me How Contribution Margin Ratio a. Young Company budgets sales of $112,900,000, fixed costs of $25,000,000, and variable costs of $66,611,000. What is the contribution margin ratio for Young Company? % b. If the contribution margin ratio for Martinez Company is 40%, sales were $34,800,000, and fixed costs were $1,500,000, what was the operating income? $4 6:39 PM 63°F 11/5/2021arrow_forwardThe actual and planned data for Underwater University for the Fall term were as follows: Actual Planned Enrollment 4,500 4,125 Tuition per credit hour $120 $135 Credit hours 60,450 43,200 Registration, records, and marketing costs per enrolled student $275 $275 Instructional costs per credit hour $64 $60 Depreciation on classrooms and equipment $825,600 $825,600 Registration, records, and marketing costs vary by the number of enrolled students, while instructional costs vary by the number of credit hours. Depreciation is a fixed cost. Prepare a variable costing income statement showing the contribution margin and operating income for the Fall term. Underwater University Variable Costing Income Statement For the Fall Term Revenue $ Variable costs: Registration, records, and marketing costs $ Instructional costs Total variable costs $ Contribution margin $ Depreciation on classrooms and equipment Operating income…arrow_forwardSuffolk County Communlty uny.edu/webapps/assessment/take/launch.jsp?course_assessment_id Question Completion Status: Quantity of Earbuds Quantity of Earbuds Price Supplied per Month 9000 Demanded per Earbud per Month 500 $20 18 1000 6000 16 1500 4500 14 2000 3500 12 2500 2500 10 3000 1500 3500 800 6. 4000 100 According to the above table, at a price of $16 per earbud, there is a shortage of 1500 earbuds. a shortage of 3000 earbuds. a surplus of 3000 earbuds. an equilibrium. QUESTION 14 Price per Quantity of XDemanded Quantity of X Supplied per Time Peri od 150 Constant Quality of X $10 per Time Peri od 120arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education