Case 11 Student Spreadsheet (3)
.xlsx
keyboard_arrow_up
School
Virginia Commonwealth University *
*We aren’t endorsed by this school
Course
HADM-608
Subject
Finance
Date
Apr 3, 2024
Type
xlsx
Pages
18
Uploaded by PresidentDiscovery9235 on coursehero.com
Model
Page 1
CASE 11 CENTURY OAKS HEALTH
Budgeting Concepts
Student Version
This case illustrates the use of budgeting to propose a new clinic site and help make operating de
model extends out to Column AR.
The model consists of a complete base case analysis--no changes need to be made to the existin
spreadsheet have been replaced by zeros. Students must select appropriate input values and en
the base case solution will appear.
INPUT DATA:
Operation Volume Assumptions:
MD
AP
1st 6 Months
12 Months
1st 6 Months
Clinic Days / Week
5
5
5
Clinic Hours / Day
4.5
4.5
6
Visits / Hour
2.5
3
2.5
Inpatient Consults Days / Week
5
5
Inpatient Consults Hours / Day
2.5
2.5
Inpatient Consults / Hour
2
2
Note: Diagnostic Reading is unpredictable and small percentage of effort.
Working Weeks
18
48
5.1
% New Patient Visits (NPV)
70%
70%
10%
% Return Patient Visits (RPV)
30%
30%
90%
Information to Drive Revenue Assumptions
Revenue Ass
New Patient Visits (NPV)- Clinic
CPT Code
Office Visit Description
wRVU Value Charge
Average Reve
99201 NPV, Level I
0.45 35.46 $ 106.38 99202 NPV, Level II
0.88 54.16 99203 NPV, Level III
1.34 99.30 99204 NPV, Level IV
2.30 154.63 99205 NPV, Level V
3.00 188.36 MODEL-GENERATED DATA section. However, values in the I
NPUT DATA section of the studen
them into the cells with values colored red
. After this is done, any error cells will be corrected and
Model
Page 2
Return Patient Visits (RPV)- Clinic
CPT Code
Office Visit Description
wRVU Value Charge
Average Reve
99211 RPV, Level I
0.17 3.03 $ 60.92 99212 RPV, Level II
0.45 30.45 99213 RPV, Level III
0.92 57.59 99214 RPV, Level IV
1.42 89.00 99215 RPV, Level V
2.00 124.51 Inpatient Consults (IC)
CPT Code
Office Visit Description
wRVU Value Charge
Average Reve
99251 IC, Level I
1.00 94.61 $ 152.55 99252 IC, Level II
1.50 118.57 99253 IC, Level III
2.27 135.28 99254 IC, Level IV
3.25 189.43 99255 IC, Level V
4.00 224.85 Expense Assumptions
MD
APP
Annual Provider Compensation
$ 425,000 $ 120,000 % Benefits
18%
21%
Benefit Expense
$ 76,500 $ 25,200 Total Annual Provider Expense
$ 501,500 $ 145,200 # Months Worked in 1st 6 Months
6
3
1st 6 Months Expense
$ 250,750 $ 36,300 Staffing Expenses
Annual
% FTE
12 Month Comp
Clinic Coordinator
$ 70,000 0.50 $ 35,000 CMA
$ 36,000 1.00 $ 36,000 Clinical Support Specialist
$ 40,000 1.00 $ 40,000 Total Staffing Expenses
$ 146,000 $ 111,000 IT Operations Upfront Costs:
PC & Peripheral Hardware
$ 6,865 Network Equipment
$ 27,540 Telecommunications
$ 1,296 AV
$ - Misc
$ 6,419 Facilities Upfront Costs:
Furniture
$ 3,000 Exam tables
$ 4,800 $ 800 per table
6
To complete
assumption
calculation o
location. On
amounts an
Model
Page 3
AED
$ 1,200 Misc
$ 1,000 Ongoing Operational Expenses
Annual Annual Lease
$ 60,800 $16 per sq ft
3,800
Additional Operating Expenses
Annual Monthly
IT
$ 83,748 $ 6,979 Utilities
$ 1,500 $ 125 Cleaning
$ 2,820 $ 235 Supplies
$ 600 $ 50 MODEL-GENERATED DATA:
Budget Analysis:
Revenue Calculations based upon Volume and Revenue Assumptions
Physician Volumes
MD Volumes- Clinic
APP Volumes
1st 6 Months 12 Months
1st 6 Months
Days/Week- Clinic
5
5
5
Ambulatory Hours/Day
4.5
4.5
6
Clinic Visits/Hour
2.5
3
2.5
Clinic Visits/Week
56 68 75 Weeks During Time Period
18
48
5.1
Clinic Visits During Time Period
1,013 3,240 383 % Visits- NPV
70%
70%
10%
% Visits- RPV
30%
30%
90%
Total Clinic Volume- NPV
709 2,268 38 Total Clinic Volume- RPV
304 972 344 Average Revenue / NPV
$ 106.38 $ 106.38 $ 106.38 Average Revenue / RVP
$ 60.92 $ 60.92 $ 60.92 Total Revenue for NPV Clinic Visits
$ 75,398 $ 241,274 $ 4,069 Total Revenue for RPV Clinic Visits
$ 18,503 $ 59,210 $ 20,970 Total Clinic Revenue
$ 93,901 $ 300,485 $ 25,039 MD Volumes- Inpatient Consults
1st 6 Months 12 Months
Days/Week- Inpatient Consults
5
5
Consult Hours/Day
2.5
2.5
Consults/Hour
2
2
Model
Page 4
Consults/Week
25
25
Weeks During Time Period
18
48
Consult Volumes During Time Period
450
1200
Average Revenue / Consult
$ 152.55 $ 152.55 Total Consult Revenue
$ 68,647 $ 183,058 Revenue Calculation Summary
MD Revenue
APP Revenue
1st 6 Months12 Months
1st 6 Months 12 Months
Clinic Revenue
$ 93,901 $ 300,485 $ 25,039 $ 235,665 Consult Revenue
$ 68,647 $ 183,058 Total Revenue
$ 162,548 $ 483,542 $ 25,039 $ 235,665 Total Practice Site Revenue
6 Month Budget # Weeks Assumptions
Revenue
18
Weeks
Expenses
26
Weeks
Revenue
MD
$ 162,548 APP
$ 25,039 Total Revenue
$ 187,588 Expenses
Personnel MD Compensation
$ 212,500 MD Benefits
$ 38,250 MD Expense Total (Comp +Benefits)
$ 250,750 APP Compensation
$ 30,000 Clinic Coordinator
$ 17,500 CMA
$ 18,000 Clinical Support Specialist
$ 20,000 Subtotal- Staff Compensation
$ 85,500 Staffing Benefits
$ 17,955 21%
Staffing Expense Total (Comp + Benefits)
$ 103,455
Model
Page 5
Total personnel expenses with benefits
$ 354,205 PC & Peripheral Hardware
$ 6,865 Network Equipment
$ 27,540 Telecommunications
$ 1,296 AV
$ - Misc
$ 6,419 IT Go Live Expense Total
$ 42,120 Furniture
$ 3,000 Exam Tables
$ 4,800 AED
$ 1,200 Misc
$ 1,000 Facility Go Live Expense Total
$ 10,000 Lease / Rent
$ 30,400 6 months
IT
$ 41,874 Utilities
$ 750 Cleaning
$ 1,410 Supplies
$ 300 Monthly Operational Expenses Total
$ 74,734 Total Non-Staffing Expenses (Go-Live + Monthly)
$ 126,854 Total Expenses
$ 481,059 Net income
$ (293,471)
12 Month Budget # Weeks Assumptions
Revenue
36
Weeks
Expenses
52
Weeks
Revenue
MD
$ 483,542 APP
$ 235,665 Total Revenue
$ 719,208 Expenses
Personnel
Model
Page 6
MD Compensation
$ 425,000 MD Benefits
$ 76,500 MD Expense Total (Comp +Benefits)
$ 501,500 APP Compensation
$ 120,000 Clinic Coordinator
$ 35,000 CMA
$ 36,000 Clinical Support Specialist
$ 40,000 Subtotal- Staff Compensation
$ 231,000 Staffing Benefits
$ 48,510 21%
Staffing Expense Total (Comp + Benefits)
$ 279,510 Total personnel expenses with benefits
$ 781,010 Lease / Rent
$ 60,800 IT
$ 83,748 Utilities
$ 1,500 Cleaning
$ 2,820 Supplies
$ 600 Monthly Operational Expenses Total
$ 149,468 Total Expenses
$ 930,478 Net income
$ (211,270)
Copyright © 2022 Foundation of the American College of Healthcare Executives. Not for sale.
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
O X
A WA Probability 1- Intro to Probabi X
B5 Probability 1: Introduction to Prol X
* O
->
webassign.net/web/Student/Assignment-Responses/submit?dep3D28685826&tags%=Dauto. <*
MY NOTES
ASK YOUR TEACHER
PRACTICE ANOTHER
Shipping constitutes a large part of the budget for online retailers. One such retailer ships fragile items that occasionally
get broken and have to be replaced/re-shipped. Historically, 8% of these items have gotten broken during shipping.
(a)If an item is shipped, what is the probability that it does not get broken? In other words, what is P(not broken)? Express
your answer as a decimal rounded to two decimal places.
(b) If the retailer ships 4 separate items, what is the probability that none will be broken during shipping? Express your
answer as a decimal rounded to three decimal places.
Submit Answer
7 O 10:29
Ili
arrow_forward
managerial exercize 4- Word
lings
Review
View
Help
Acrobat
O Tell me what ycu vant to do
AaBbCcD AaBbCcDc AaBbC AaBbCc[ AaB
三 .
T Normal
1 No Spac.
Heading 1
Heading 2
Title
Paragraph
120
Styles
Custom Lock installs window coverings for both commercial and residential cus-
tomers. The following information relates to its budgeted operations for the current vear.
Commercial
Residential
$300,000
$480,000
Revenues
Direct material costs
Direct labor costs
Overhead costs
Operating income (loss)
$ 30,000
100,000
85 000
$ 70.000
300,000
162,000
215,000
$ 85,000
532 000
52.000)
The controller, Jane Reasoner, is concerned about the residential product line. She cannot
understand why this line is not more profitable given that the installations of window cover
ings are less complex to install for residentil customers. In addition, the residential client
base resides in close proximity to the company offce, so travel costs are not as expensive on
a per client visit for residential customers. As a…
arrow_forward
II I I " I| II |I
+ **
+ + + -
10/8/2021
Chapter 5 - Homework-sehrish bashir
3. Petal Bags (PB) is a designer of high-quality backpacks and purses. Each design is made in small batches. Each spring, PB
comes out with new designs for the backpack and the purse. The company uses these designs for a year and then moves
on to the next trend. The bags are all made on the same fabrication equipment that is expected to operate at capacity. The
equipment must be switched over to a new design and set up to prepare for the production of each new batch of products.
When completed, each batch of products is immediately shipped to a wholesaler. Shipping costs vary with the number of
shipments. Budgeted information for the year is as follows:
7(Click the icon to view the budgeted information.)
Read the requirements.
Requirement 1. Identify the cost hierarchy level for each cost category.
Cost
Cost Hierarchy Level
()
(2)
Direct materials-purses
Direct materials-backpacks
Direct labor-purses
()
()
(5)…
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
Dashboard
CengageNOWv2| Online teachin x
https://v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogres.
Chapter 22
еBook
Show Me How
Production Budget
Healthy Measures Inc. produces a Bath and Gym version of its popular electronic scale. The anticipated unit sales for the scales by sales region are as follows:
Bath
Gym
Scale
Scale
Northern Region unit sales
40,000
25,000
Southern Region unit sales
75,000
35,000
Total
115,000
60,000
The finished goods inventory estimated for March 1, for the Bath and Gym scale models is 11,800 and 8,100 units, respectively. The desired finished goods inventory for March 31 for the
Bath and Gym scale models is 15,000 and 7,500 units, respectively.
Prepare a production budget for the Bath and Gym scales for the month ended March 31. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Healthy Measures Inc.
Production Budget
For the Month Ending March 31
Units Bath…
arrow_forward
S Math Models B
A wbbroncos.schoolsplp.com/enrollments/156569804/items/YU132/work?prev=LNSDS
Classes
* Western Brown Loc.
A Planner - ProgressB.
S Desmos | Graphing.
A ALEKS - Gracie Glov.
M My Classes | McGra.
Gracie Glover
Math Models B: Lesson 1 - Salary
Next Activity >
Cont
↑ Cour
v Unit
Target due: 1/14/21 58.33%
7) Choose the best answer.
What is the gross annual pay for Saul if he works 40 hours each week but also works
4 hours of overtime every two weeks? (Saul makes $27.35 an hour and gets time and
a half for overtime.)
$61,154.60
O $57,052.10
NIT
AM
O $4,266.60
OH
uis
$65.421.20
O $56,888
O D 8) Choose the best answer.
Caleb has worked hard and is offered a salaried position with the same company. He
is offered $28,000, but will be expected to work 44 hours per week with no overtime
pay. How much would he be paid per year if he remained in his present job and
arrow_forward
about:blank
Blackboard Learn
sc.edu/webapps/assessment/take/launch isp?course assessment_id=_114
Remaining Time: 1 hour, 23 minutes, 35 seconds.
Question Completion Status:
A Moving to the next question prevents changes to this answer.
Question 1
What is the Payback Period for the following investment?
Year
1
2
3
4
5
O a. 3.77
Ob. 3.73
Oc. 3.89
Od. 3.96
Cash Out
$ (1,600,000)
(710,000)
Cash In
550,000
580,000
610,000
640,000
670,000
A Moving to the next question prevents changes to this answer.
000
900
F2
F3
F4
MacBook
arrow_forward
myOpenMath
Course Messages Forums Calendar | Gradebook
Home > Math 173-4 Spring 2024> Assessment
Quiz 2 (Sec. 1.5-1.7)
54 points possible 5/12 answered
Question 6
The graph of the function
y = f(x - 39)
can be obtained from the graph of
y = f(x)
by one of the following actions:
> Next Question
Home | My
Oshifting the graph of f(x) to the right 39 units
shifting the graph of f(x) to the left 39 units
shifting the graph of f(x) upwards 39 units
shifting the graph of f(x) downwards 39 units
arrow_forward
OBJECTIVE 2456
sout cost behavior that you would like to have? Explain.
Problem 3-28 HIGH-LOW METHOD, SCATTERPLOT, REGRESSION
Weber Valley Regional Hospital has collected data on all of its activities for the past 16
months. Data for cardiac nursing care follow:
Y
x
Cost
Hours of Nursing Care
May 2010
$59,600
1,400
June 2010
57,150
1,350
July 2010
61,110
1,460
August 2010
65,800
1,600
(continued)
Chapter 3 Cost Behavior
Y
Cost
x
Hours of Nursing Care
September 2010
69,500
1,700
October 2010
64,250
1,550
November 2010
52,000
1,200
December 2010
66,000
1,600
January 2011
83,000
1,800
February 2011
66,550
1,330
March 2011
79,500
1,700
April 2011
76,000
1,600
May 2011
June 2011
68,500
1,400
73,150
1,550
July 2011
August 2011
73,175
1,505
66,150
1,290
Required:
1. Using the high-low method, calculate the variable rate per hour and the fixed cost
for the nursing care activity.
125
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
My Questions | bartleby
b
References
X
Chapter 3 Quiz
CCamden County College
ounty College Ha
Ahttps://camdencc.instructure.com/courses/3788/assignments/35967?module item id=88693
les
Question 7
s
View Policies
uncements
Current Attempt in Progress
ssions
The last department in a production process shows the following information at the end of the period:
rences
borations
Units
Beginning Work in Process 25000
Started into Production
PLUS
ort
263000
Ending Work in Process
49200
Central
How many units have been transferred out to finished goods during the period?
288000.
O 263000.
O312200.
O 238000.
eTextbook and Media
e to search
hp
arrow_forward
Assignment: Chapter 12 Homework
Time Remaining: 0:58:20
Questions Problem 12.08 (New Project Analysis)
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
0
eBook
Assignment Score: 78.57%
Save Submit Assignment for Grading
Question 4 of 14 ►
Check My Work
You must evaluate the purchase of a proposed spectrometer for the R&D department. The purchase price of the spectrometer including modifications is
$140,000, and the equipment will be fully depreciated at the time of purchase. The equipment would be sold after 3 years for $32,000. The equipment would
require an $8,000 increase in net operating working capital (spare parts inventory). The project would have no effect on revenues, but it should save the firm
$43,000 per year in before-tax labor costs. The firm's marginal federal-plus-state tax rate is 25%.
a. What is the initial investment outlay for the spectrometer after bonus depreciation is considered, that is, what is the Year 0 project cash flow? Enter your
answer as a positive value.…
arrow_forward
ezto.mheducation.com
Homework: Cost Management and Allocation Assignment
Question 7- Homework: Cost Management and Allocation Assignment- Connect
Homework: Cost Management and Allocation Assignm... i
Saved
Help
Save & Exit
Submit
Check my work
State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments
(Deposits and Loans). A summary of costs and other data for each department prior to allocation of service department costs for the
year ended December 31 follows.
4.
points
Administration Communications
Facilities
Deposits
$8,320,000 $4,600,000
447, 000
Loans
Direct costs
$200,000
24,000
$290,000
31,000
$253,000
20,500
Employee hours
Number of employees
Square footage occupied
Skipped
360,000
8.
14
6.
230
130
4,600
13,800
5,100
244, 100
203,300
The costs of the service departments are allocated on the following bases: Administration, employee-hours; Communications, number
of employees; and Facilities, square…
arrow_forward
engageNOWv2 | Online teach x
+
n/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
O SOFTWARE UPDATE
34m
macOS Big Sur 11.3.1 is available and will be instal
later tonight.
еBook
E Print Item
Single plantwide factory overhead rate
Bach Instruments Inc. makes three musical instruments: flutes, clarinets, and oboes. The budgeted factory overhead cost is $88,320. Overhead is allocated to the three
products on the basis of direct labor hours. The products have the following budgeted production volume and direct labor hours per unit:
Budgeted Production
Direct Labor Hours Per
Volume
Unit
Flutes
2,600 units
0.4
Clarinets
600
1.6
Oboes
1,400
1.2
If required, round all per unit answers to the nearest cent.
a. Determine the single plantwide overhead rate.
X per direct labor hour
b. Use the overhead rate in (a) to determine the amount of total and per-unit overhead allocated to each of the three products.
Total
Per Unit
Factory Overhead Cost
Factory…
arrow_forward
Insert
Draw
Page Layout
Formulas
Data
Review
View
Tell me
Calibri (Body)
v A A
11
Wrap Text v
В I
U
Merge & Centem
fx
B
E
F
CLR
Question
Lesson
Objective #
Ma
Q4: Solve the following 2 problems related to employee compensation
CLR 1-Obj. 4
L2
a. Jon is employed at annual salary of $41995. His regular work week is 38 hours and he is paid
semi-monthly
i.
What is Jon's Gross pay per period?
ii.
What is hourly rate of pay?
iii.
What is his gross pay for a period in which work 12 hours of overtime and he is paid overtime at time and a half of
What is a salesperson's commission on net sales of $17800 if the commission is paid on a
sliding scale of 7%% on the first $7000, 8%% on the next $8000 and 12.5% on sales over $15000?
b.
CLR 1- Obj. 5
L2
Mark
Q5: Solve the following 3 problems related to GST, HST, PST,
公 四
arrow_forward
Chapter 2 (Continued): Basic Cost Management Concepts
College offers students a number of different majors and disciplines. These majors and disciplines have department chairpersons who are responsible for the department budget preparation. Please define direct costs and indirect costs and then prepare a list of three direct and three indirect costs for the Accounting Department at College. Hint: See Exercise 10 in Chapter 2 of your eText.
arrow_forward
NOWV2 | Online teach x
+
O SOFTWARE UPDATE
eAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress%3false
macOS Big Sur 11.3.1 is available and will be in
later tonight.
O eBook
Show Me How
E Print Item
Activity-Based Costing: Factory Overhead Costs
The total factory overhead for Bardot Marine Company is budgeted for the year at $1,167,450, divided into four activities: fabrication, $507,000; assembly, $210,000;
setup, $245,700; and inspection, $204,750. Bardot Marine manufactures two types of boats: speedboats and bass boats. The activity-base usage quantities for each
product by each activity are as follows:
Fabrication
Assembly
Setup
Inspection
Speedboat
9,750 dlh
31,500 dlh
70 setups
122 inspections
Bass boat
29,250
10,500
515
853
39,000 dlh
42,000 dlh
585 setups
975 inspections
Each product is budgeted for 5,500 units of production for the year.
a. Determine the activity rates for each activity.
Fabrication
$
per direct labor hour
Assembly
5
V per…
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
takeAssignmentMain.do?invoker=&ta... A
Desired inventory, November 30
Price per pound
Units required for production:
12" pizza
16" pizza
Total units available
Total units to be purchased
Unit Price
2,000 lbs. 1,200 lbs.
$0.60
$0.50
Prepare November's direct materials purchases budget for Tobin's Frozen Pizza Inc. For those boxes in which you must enter subtracted or negative
numbers use a minus sign.
Total direct materials to be purchased
2,800 lbs.
$0.85
Tobin's Frozen Pizza Inc.
Direct Materials Purchases Budget
For the Month Ending November 30
Direct Materials
Dough
Direct Materials
Tomato
Direct Materials
Cheese
@
Total
99 g
arrow_forward
ng
Heading 1
Heading 2
Title
Styles
Г
Comments
Editing
v
Share
Find
v
E
rM
Replace
Dictate Sensitivity Editor
Add-ins
Read on
reMarkable
Select
Editing
Voice Sensitivity Editor
Add-ins
reMarkable
year. Each set requires 2.5 hours to polish the material.
If polishing labor costs $15.00 per hour, determine the direct labor cost budget for polishing for
3,000,000
the year.
EX.22-08.ALGO Professional Labor Cost Budget for a Service Company
Rollins and Cohen, CPAs, offer three types of services to clients: auditing, tax, and small
business accounting. Based on experience and projected growth, the following billable hours
have been estimated for the year ending December 31, 2017:
Audit Department:
Staff
Partners
Tax Department:
m, CPAS
Cost Budget
Staff
Partners
Small Business Accounting
Department:
Staff
Billable
Hours
44,200
6,600
32,300
4,000
5,700
800
Partners
Based on the data provided above and assuming that the average compensation per hour for
staff is $50 and for partners is $145,…
arrow_forward
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
Edit
View
History
Bookmarks
People
Tab
Window
Help
N Academic Tools :: Northern Virgi X
63%
Mon 12:07 PM
weCS Virginia Community College Syst X
N CHAPTER 08 HW NOVA
learn.vccs.edu/courses/240149/assignments/4704240?module_item_id=17254910
https://checkout.wileyplus.com/ X
des
View Policies
rse Evaluations
Current Attempt in Progress
A Policies
Cullumber Co. has the following transactions related to notes receivable during the last 2 months of the year. The company does not make entries to
accrue interest except at December 31.
r.com: 24/7 On-
Tutoring
Nov. 1 Loaned $53,400 cash to C. Bohr on a 12-month, 9% note.
ary Resources
Dec. 11 Sold goods to K. R. Pine, Inc., receiving a $5,400, 90-day, 8% note.
16 Received a $9,600, 180-day, 8% note to settle an open account from A. Murdock.
31 Accrued interest revenue on all notes receivable.
Journalize the transactions for Cullumber Co. (Omit cost of goods sold entries.) (Credit account titles are automatically indented when amount is entered.…
arrow_forward
ER
ES
Study
Question 6
In applying the high-low method, what is the fixed cost?
Month
Miles
January 76000
February 52000
March
66000
April
84000
O$12000
$40000
O$45000
$32000
Total Cost
$122000
110000
n the web and Windows
118000
150000
Click if you would like to Show Work for this question: Open Show Work
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Financial & Managerial Accounting
Accounting
ISBN:9781337119207
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- O X A WA Probability 1- Intro to Probabi X B5 Probability 1: Introduction to Prol X * O -> webassign.net/web/Student/Assignment-Responses/submit?dep3D28685826&tags%=Dauto. <* MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER Shipping constitutes a large part of the budget for online retailers. One such retailer ships fragile items that occasionally get broken and have to be replaced/re-shipped. Historically, 8% of these items have gotten broken during shipping. (a)If an item is shipped, what is the probability that it does not get broken? In other words, what is P(not broken)? Express your answer as a decimal rounded to two decimal places. (b) If the retailer ships 4 separate items, what is the probability that none will be broken during shipping? Express your answer as a decimal rounded to three decimal places. Submit Answer 7 O 10:29 Iliarrow_forwardmanagerial exercize 4- Word lings Review View Help Acrobat O Tell me what ycu vant to do AaBbCcD AaBbCcDc AaBbC AaBbCc[ AaB 三 . T Normal 1 No Spac. Heading 1 Heading 2 Title Paragraph 120 Styles Custom Lock installs window coverings for both commercial and residential cus- tomers. The following information relates to its budgeted operations for the current vear. Commercial Residential $300,000 $480,000 Revenues Direct material costs Direct labor costs Overhead costs Operating income (loss) $ 30,000 100,000 85 000 $ 70.000 300,000 162,000 215,000 $ 85,000 532 000 52.000) The controller, Jane Reasoner, is concerned about the residential product line. She cannot understand why this line is not more profitable given that the installations of window cover ings are less complex to install for residentil customers. In addition, the residential client base resides in close proximity to the company offce, so travel costs are not as expensive on a per client visit for residential customers. As a…arrow_forwardII I I " I| II |I + ** + + + - 10/8/2021 Chapter 5 - Homework-sehrish bashir 3. Petal Bags (PB) is a designer of high-quality backpacks and purses. Each design is made in small batches. Each spring, PB comes out with new designs for the backpack and the purse. The company uses these designs for a year and then moves on to the next trend. The bags are all made on the same fabrication equipment that is expected to operate at capacity. The equipment must be switched over to a new design and set up to prepare for the production of each new batch of products. When completed, each batch of products is immediately shipped to a wholesaler. Shipping costs vary with the number of shipments. Budgeted information for the year is as follows: 7(Click the icon to view the budgeted information.) Read the requirements. Requirement 1. Identify the cost hierarchy level for each cost category. Cost Cost Hierarchy Level () (2) Direct materials-purses Direct materials-backpacks Direct labor-purses () () (5)…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,000arrow_forwardDashboard CengageNOWv2| Online teachin x https://v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogres. Chapter 22 еBook Show Me How Production Budget Healthy Measures Inc. produces a Bath and Gym version of its popular electronic scale. The anticipated unit sales for the scales by sales region are as follows: Bath Gym Scale Scale Northern Region unit sales 40,000 25,000 Southern Region unit sales 75,000 35,000 Total 115,000 60,000 The finished goods inventory estimated for March 1, for the Bath and Gym scale models is 11,800 and 8,100 units, respectively. The desired finished goods inventory for March 31 for the Bath and Gym scale models is 15,000 and 7,500 units, respectively. Prepare a production budget for the Bath and Gym scales for the month ended March 31. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Healthy Measures Inc. Production Budget For the Month Ending March 31 Units Bath…arrow_forwardS Math Models B A wbbroncos.schoolsplp.com/enrollments/156569804/items/YU132/work?prev=LNSDS Classes * Western Brown Loc. A Planner - ProgressB. S Desmos | Graphing. A ALEKS - Gracie Glov. M My Classes | McGra. Gracie Glover Math Models B: Lesson 1 - Salary Next Activity > Cont ↑ Cour v Unit Target due: 1/14/21 58.33% 7) Choose the best answer. What is the gross annual pay for Saul if he works 40 hours each week but also works 4 hours of overtime every two weeks? (Saul makes $27.35 an hour and gets time and a half for overtime.) $61,154.60 O $57,052.10 NIT AM O $4,266.60 OH uis $65.421.20 O $56,888 O D 8) Choose the best answer. Caleb has worked hard and is offered a salaried position with the same company. He is offered $28,000, but will be expected to work 44 hours per week with no overtime pay. How much would he be paid per year if he remained in his present job andarrow_forward
- about:blank Blackboard Learn sc.edu/webapps/assessment/take/launch isp?course assessment_id=_114 Remaining Time: 1 hour, 23 minutes, 35 seconds. Question Completion Status: A Moving to the next question prevents changes to this answer. Question 1 What is the Payback Period for the following investment? Year 1 2 3 4 5 O a. 3.77 Ob. 3.73 Oc. 3.89 Od. 3.96 Cash Out $ (1,600,000) (710,000) Cash In 550,000 580,000 610,000 640,000 670,000 A Moving to the next question prevents changes to this answer. 000 900 F2 F3 F4 MacBookarrow_forwardmyOpenMath Course Messages Forums Calendar | Gradebook Home > Math 173-4 Spring 2024> Assessment Quiz 2 (Sec. 1.5-1.7) 54 points possible 5/12 answered Question 6 The graph of the function y = f(x - 39) can be obtained from the graph of y = f(x) by one of the following actions: > Next Question Home | My Oshifting the graph of f(x) to the right 39 units shifting the graph of f(x) to the left 39 units shifting the graph of f(x) upwards 39 units shifting the graph of f(x) downwards 39 unitsarrow_forwardOBJECTIVE 2456 sout cost behavior that you would like to have? Explain. Problem 3-28 HIGH-LOW METHOD, SCATTERPLOT, REGRESSION Weber Valley Regional Hospital has collected data on all of its activities for the past 16 months. Data for cardiac nursing care follow: Y x Cost Hours of Nursing Care May 2010 $59,600 1,400 June 2010 57,150 1,350 July 2010 61,110 1,460 August 2010 65,800 1,600 (continued) Chapter 3 Cost Behavior Y Cost x Hours of Nursing Care September 2010 69,500 1,700 October 2010 64,250 1,550 November 2010 52,000 1,200 December 2010 66,000 1,600 January 2011 83,000 1,800 February 2011 66,550 1,330 March 2011 79,500 1,700 April 2011 76,000 1,600 May 2011 June 2011 68,500 1,400 73,150 1,550 July 2011 August 2011 73,175 1,505 66,150 1,290 Required: 1. Using the high-low method, calculate the variable rate per hour and the fixed cost for the nursing care activity. 125arrow_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. ICarrow_forwardMy Questions | bartleby b References X Chapter 3 Quiz CCamden County College ounty College Ha Ahttps://camdencc.instructure.com/courses/3788/assignments/35967?module item id=88693 les Question 7 s View Policies uncements Current Attempt in Progress ssions The last department in a production process shows the following information at the end of the period: rences borations Units Beginning Work in Process 25000 Started into Production PLUS ort 263000 Ending Work in Process 49200 Central How many units have been transferred out to finished goods during the period? 288000. O 263000. O312200. O 238000. eTextbook and Media e to search hparrow_forwardAssignment: Chapter 12 Homework Time Remaining: 0:58:20 Questions Problem 12.08 (New Project Analysis) 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 0 eBook Assignment Score: 78.57% Save Submit Assignment for Grading Question 4 of 14 ► Check My Work You must evaluate the purchase of a proposed spectrometer for the R&D department. The purchase price of the spectrometer including modifications is $140,000, and the equipment will be fully depreciated at the time of purchase. The equipment would be sold after 3 years for $32,000. The equipment would require an $8,000 increase in net operating working capital (spare parts inventory). The project would have no effect on revenues, but it should save the firm $43,000 per year in before-tax labor costs. The firm's marginal federal-plus-state tax rate is 25%. a. What is the initial investment outlay for the spectrometer after bonus depreciation is considered, that is, what is the Year 0 project cash flow? Enter your answer as a positive value.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial & Managerial AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Financial & Managerial Accounting
Accounting
ISBN:9781337119207
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning