BUS-FPX4064 Assessment 2 Part 1 Report
docx
School
Barstow Community College *
*We aren’t endorsed by this school
Course
FPX2001
Subject
Accounting
Date
Jan 9, 2024
Type
docx
Pages
4
Uploaded by wlorraine715
Applying Cost Accounting Concepts to analyze and Estimate costs
1
Applying Cost Accounting Concepts to Analyze and Estimate Costs
Adi’Yah Williams
Capella University
Applying Cost Accounting Concepts to analyze and Estimate costs
2
1. Analyze the data and your results. Explain your reasons for supporting or rejecting your cost equation. Show all calculations.
There are a variety of delivery services that each company provides. Management is seeking the volume of a specific delivery that generates a pre-tax amount of $11,000 per month in operating profit. Overhead costs are estimated at $9,900 monthly for fixed costs and $12 for each delivery for variable expenses. The company should use regression analysis to evaluate its data. The monthly overhead is $26,501+ $10.70 per delivery based on the analysis of the volume of deliveries that would generate $11,000 per month in operating profits prior to taxes. If the company charges $22 for each delivery and the variable cost is $12 for each delivery, the contribution margin is $10. The contribution margin to calculate the number of deliveries
required to generate $11,000 in operating profits: ●
Number of deliveries = Operating profit / Contribution margin
●
Number of deliveries = $11,000 / $10
●
Number of deliveries = 1,100 The company would need to have 1,100 monthly deliveries in order to generate the pre-
taxed amount of $11,000 in operating profits.
Applying Cost Accounting Concepts to analyze and Estimate costs
3
2. Write a report that informs management about the correct volume that will generate $11,000 per month in operating profits before taxes.
To Management:
This report aims to represent our analysis result to determine the volume of deliveries required to generate $11,000 pre-tax and operating profits. While given the previous data, the monthly overhead is estimated at $26,501 plus $10.70 for each delivery. $26,50 represents the fixed costs, while $ 10.75 represents the delivery cost. We have also compared the actual and predicted costs for each month and found the anticipated expenses are reasonably similar to the actual costs. There are differences in
the predicted costs for some months because some factors are not included in the regression equation, such as changes in market conditions or one-time events. The company charges $22 per delivery, and the variable costs $12. Therefore, the contribution margin is 10. That's the company's $22 per delivery minus the variable expense per delivery. We will use the contribution margin to calculate the deliveries required to generate $11,000 in operating profit before taxes. ●
Number of deliveries = Operating profit / Contribution margin
●
Number of deliveries = $11,000 / $10
●
Number of deliveries = 1,100 The company would need to have 1,100 monthly deliveries in order to generate the pre-
taxed amount of $11,000 in operating profits. Considering our analysis, we recommend the company make 1,100 deliveries monthly to achieve the $11,000 before tax. We utilized regression analysis to evaluate the cost equation, which provides a more precise estimation of the fixed and variable
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
Applying Cost Accounting Concepts to analyze and Estimate costs
4
costs. We also operated the contribution margin to help determine the volume of deliveries required to reach that $11,000 operations profit goal. If the company regularly
monitors the volume of deliveries and operating profits, the goal is to have a higher likelihood of success.
Related Documents
Related Questions
Howard Cooper, the president of Vernon Computer Services, needs your help. He wonders about the potential effects on the firm's net
income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3.
Standard rate and variable costs
Service rate per hour
Labor cost
Overhead cost
Selling, general, and administrative cost
Expected fixed costs
Facility maintenance
Selling, general, and administrative
Required A
Required:
a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 42,000 hours of
services in Year 3.
b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can
achieve. According to the consultant's analysis, if Vernon charges customers $83 per hour, the firm can achieve 52,000 hours of
services. Prepare a flexible budget using the consultant's assumption.
c. The same consultant also suggests that if…
arrow_forward
Howard Cooper, the president of Thornton Computer Services, needs your help. He wonders about the potential effects on the firm's
net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3.
Standard rate and variable costs
Service rate per hour
Labor cost
Overhead cost
Selling, general, and administrative cost
Expected fixed costs
Facility maintenance
Selling, general, and administrative
Required:
a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 42,000 hours of
services in Year 3.
b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can
achieve. According to the consultant's analysis, if Thornton charges customers $79 per hour, the firm can achieve 48,000 hours of
services. Prepare a flexible budget using the consultant's assumption.
c. The same consultant also suggests that if the…
arrow_forward
Howard Cooper, the president of Stuart Computer Services, needs your help. He wonders about the potential effects on the firm's net
income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3.
Standard rate and variable costs
Service rate per hour
Labor cost
Overhead cost
Selling, general, and administrative cost
Expected fixed costs
Facility maintenance
Selling, general, and administrative
Required:
a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 30,000 hours of
services in Year 3.
b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can
achieve. According to the consultant's analysis, if Stuart charges customers $80 per hour, the firm can achieve 36,000 hours of
services. Prepare a flexible budget using the consultant's assumption.
c. The same consultant also suggests that if the firm…
arrow_forward
i need the answer quickly
arrow_forward
Can you please provide solution this general accounting question?
arrow_forward
Please help me with show all calculation and do not give solution in image format thanku
arrow_forward
9
arrow_forward
Home
* CengageNOWv2 | Online teachin x
+.
takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
eBook
Show Me How
E Print Item
Flexible Budget for Selling and Administrative Expenses for a Service Company
Digital Solutions Inc. uses flexible budgets that are based on the following data:
Sales commissions
8% of sales
Advertising expense
15% of sales
Miscellaneous administrative expense
$10,000 per month plus 4% of sales
Office salaries expense
$50,000 per month
Customer support expenses
$20,000 per month plus 30% of sales
Research and development expense
$75,000 per month
Prepare a flexible selling and administrative expenses budget for October for sales volumes of $500,000, $750,000, and $1,000,000. (Use Exhibit 5 as a model.)
Digital Solutions Inc.
Flexible Selling and Administrative Expenses Budget
For the Month Ending October 31
Total sales
$500,000 $750.000 $1,000,000
Variable cost:
Sales commissions
Advertising expense
Miscellaneous…
arrow_forward
Please provide Answer hello please
arrow_forward
Download and fill out the Section 5 Comprehensive Problem Template attached below to complete the problems (ignore question 5-2 as this applies to the "combined accounting and finance" course).
Problem 5-1
Redlands Inc. sells one product for $5. The variable cost per item is $3, and the fixed costs for the firm are $40.
Required:
a. Compute the breakeven point in units.
b. Compute the number of units and sales revenue needed to achieve a $20 profit. (Ignore income taxes.)
c. Assume that the income tax rate for Redlands is 40%. Compute the number of units and sales revenue needed to achieve an $18 net profit.
d. Compute the number of units and sales revenue needed to achieve an 8% profit margin. (Ignore income taxes.)
e. Compute the number of units and sales revenue needed to achieve a 12% net profit margin. (Assume a 40% income tax rate.)
f. Assume that Redlands currently sells 40 units. Redlands estimates that if it increased sales price to $6 per unit demand would decrease by…
arrow_forward
.
arrow_forward
Please given correct answer general accounting
arrow_forward
Solve this Financial Accounting Problem
arrow_forward
Need help with this question solution general accounting
arrow_forward
5. Need help with the formulas. Please use same numbers and letters as seen in pictures.
arrow_forward
ngageNOWv2 | Online teachin x
takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator%=&inprogress=false
eBook
Show Me How
Print Item
Flexible Budget for Selling and Administrative Expenses for a Service Company
Daybreak Technologies Inc. uses flexible budgets that are based on the following data:
Sales commissions
8% of sales
Advertising expense
15% of sales
Miscellaneous administrative expense
$1,300 per month plus 3% of sales
Office salaries expense
$12,000 per month
Customer support expenses
$1,800 plus 4%
sales
Research and development expense
$4,000 per month
Prepare a flexible selling and administrative expenses budget for April for sales volumes of $80,000, $100,000, and $120,00
Daybreak Technologies Inc.
Flexible Selling and Administrative Expenses Budget
For the Month Ending April 30
Total sales
$80,000 $100,000
$120,000
Variable cost:
Sales commissions
Advertising expense
Miscellaneous administrative expense
Customer support expenses
Total variable cost…
arrow_forward
Font
Paragraph
Styles
The Borstal Company has to choose between two machines that do the same job but have different lives. The two machines have the
following costs:
Year
Machine A
Machine B
0
$ 43,500
$ 53,500
1
10,700
9,400
2
10,700
9,400
3
4
10,700+ replace
9,400
9,400+ replace
These costs are expressed in real terms.
a. Suppose you are Borstal's financial manager. If you had to buy one or the other machine and rent it to the production manager
for that machine's economic life, what annual rental payment would you have to charge? Assume a 7% real discount rate and
ignore taxes.
Note: Do not round intermediate calculations. Enter your answers as a positive value rounded to 2 decimal places.
b. Which machine should Borstal buy?
c. If there is steady 5% per year inflation, what will be the annual rental payment for machine B for the second year?
Note: Enter your answer as a positive value rounded to 2 decimal places.
a. Machine A
a. Machine B
b. Which machine should Borstal buy?
c.…
arrow_forward
Problem 1. Mahinahon Company would like to institute an activity-based costing system to price products. The company's Purchasing Department incurs costs of P550,000 per year and has six employees.
Purchasing has determined the three major activities that occur during the year.
Activity
Allocation
Measure
# of People
Total Cost
Issuing purchase orders
# of purchase orders
1
P285,000
Reviewing receiving reports
# of receiving reports
2
P190,000
Making phone calls
# of phone calls
3
P220,000
During the year, 50,000 phone calls were made in the department; 15,000 purchase orders were issued;
and 10,000 shipments were received. Product A required 200 phone calls, 150 receiving reports, and
50 purchase orders. Product B required 350 phone calls, 400 receiving reports, and 100 purchase
orders.
1Determine the amount of purchasing department cost that should be assigned to each
of these products.
1.2. Determine purchasing department cost per…
arrow_forward
Please need answer the following requirements a and b on these financial accounting question
arrow_forward
Hi, can someone help me with this please?
arrow_forward
Please provide this question solution general accounting
arrow_forward
Please help me with all answers thanku
arrow_forward
a. What is the box annual sales volume for each area to be able to compete on a competitive advantage strategy with competitors?
b. What do you suggest to the company based on the cost data above for the location of its factory construction? Explain why and use the calculation data so that decision making can be in accordance with the company strategy that you have learned.
arrow_forward
tutor account expert please solve this. Short answer need
arrow_forward
Need help with this accounting question
arrow_forward
Identify Fixed and Variable Costs
Intuit Inc. develops and sells software products for the personal finance market, including popular titles such as Quickbooks® and TurboTax®. Classify each of the following costs and expenses for this company as either variable or fixed to the number of units produced and sold:
a. Packaging costs
b. Sales commissions
c. Property taxes on general offices
d. Shipping expenses
e. Straight-line depreciation of computer equipment
f. President’s salary
g. Salaries of software developers
h. Salaries of human resources personnel
i. Wages of telephone order assistants
j. Users' guides
arrow_forward
Hello tutor please provide this question solution general accounting
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning

Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning

Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Related Questions
- Howard Cooper, the president of Vernon Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative Required A Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 42,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Vernon charges customers $83 per hour, the firm can achieve 52,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if…arrow_forwardHoward Cooper, the president of Thornton Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 42,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Thornton charges customers $79 per hour, the firm can achieve 48,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the…arrow_forwardHoward Cooper, the president of Stuart Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 30,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Stuart charges customers $80 per hour, the firm can achieve 36,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm…arrow_forward
- 9arrow_forwardHome * CengageNOWv2 | Online teachin x +. takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false eBook Show Me How E Print Item Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales commissions 8% of sales Advertising expense 15% of sales Miscellaneous administrative expense $10,000 per month plus 4% of sales Office salaries expense $50,000 per month Customer support expenses $20,000 per month plus 30% of sales Research and development expense $75,000 per month Prepare a flexible selling and administrative expenses budget for October for sales volumes of $500,000, $750,000, and $1,000,000. (Use Exhibit 5 as a model.) Digital Solutions Inc. Flexible Selling and Administrative Expenses Budget For the Month Ending October 31 Total sales $500,000 $750.000 $1,000,000 Variable cost: Sales commissions Advertising expense Miscellaneous…arrow_forwardPlease provide Answer hello pleasearrow_forward
- Download and fill out the Section 5 Comprehensive Problem Template attached below to complete the problems (ignore question 5-2 as this applies to the "combined accounting and finance" course). Problem 5-1 Redlands Inc. sells one product for $5. The variable cost per item is $3, and the fixed costs for the firm are $40. Required: a. Compute the breakeven point in units. b. Compute the number of units and sales revenue needed to achieve a $20 profit. (Ignore income taxes.) c. Assume that the income tax rate for Redlands is 40%. Compute the number of units and sales revenue needed to achieve an $18 net profit. d. Compute the number of units and sales revenue needed to achieve an 8% profit margin. (Ignore income taxes.) e. Compute the number of units and sales revenue needed to achieve a 12% net profit margin. (Assume a 40% income tax rate.) f. Assume that Redlands currently sells 40 units. Redlands estimates that if it increased sales price to $6 per unit demand would decrease by…arrow_forward.arrow_forwardPlease given correct answer general accountingarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning

Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning

Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning

Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning