BUS 400 Module Six Assignment Template
.pdf
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
400
Subject
Business
Date
Jan 9, 2024
Type
Pages
2
Uploaded by Jasmine8394
Jasmine Bowser BUS 400 Module 6 12/03/2023 BUS 400 Module Six Assignment Template 24-Month Pro Forma Insert the appropriate values in each row. Previous Fiscal Year (USD in Millions) 24-Month Projections Sales $513,983 $608,555 Cost of goods sold $288,831 $341,975 Gross profit $225,152 $266,579 Selling expenses $138,428 $163,898 Administrative expenses $11,891 $14,078 Total operating expense $501,735 $594,054 Income from operations $12,248 $14,501 Other income - - Income before tax and interest $
-5,936 $-4,843 Other expense (interest) $2,367 $2,802 Income before income tax $-5936 $-4,843 Income tax expense $-3,217 $-2,625 Net income $-2,722 $-2,221 Explanation of Assumptions Using the data based on past historical financial records, Amazon.com recorded an average increase of 9.4% in sales between 2021 –
2022 without considering the effects of Amazon Fitness. The increase in Amazon’s sales may amount to about $6
08,555 million, going by this trend. This remarkable success is primarily due to the company’s efforts to diversify its revenue-earning avenues. This could include the fitness sector which may help maintain their success even further. The fact that the company already sells fitness related products gives them an opportunity to diversify by using the current resources available. Introducing Amazon Fitness as a new service on Amazon.com is not a risk considering the projected increases in revenue for the company. Despite the large expenses involved in implementing Amazon Fitness, it is expected that the income would outweigh them. Amazon fitness is based on accessible health and wellness solutions which aim at offering excellent customer services and convenience. In a nutshell, Amazon’s official announcement forecasts
that “
net sales are expected to be between $138.0 billion and $143.0 billion, or to grow between 9% and 13% compared with third quarter 2022
” (Amazon New Release Details, 2023
. Since sales increased by 9.4% from 2021 to 2022, this implies that an annual growth rate of 9.4% for the last two years will see sales figures hit $562,297 million in 2023 and $608,555 million in 2024.
Jasmine Bowser BUS 400 Module 6 12/03/2023 References Amazon Cost of goods sold 2010-2023: AMZN
. Macrotrends. (n.d.). https://www.macrotrends.net/stocks/charts/AMZN/amazon/cost-goods-sold Amazon.com announces second quarter results
. Amazon.com, Inc. - Amazon.com Announces Second Quarter Results. (2023, August 3). https://ir.aboutamazon.com/news-release/news-
release-details/2023/Amazon.com-Announces-Second-Quarter-
Results/default.aspx#:~:text=Net%20sales%20are%20expected%20to,compared%20with
%20third%20quarter%202022. Amazon.com Inc
. MarketLine Intelligence Center. (2023, December 1). https://advantage.marketline.com/ AMAZON.COM, INC.
sec.gov. (n.d.). https://www.sec.gov/Archives/edgar/data/1018724/000101872423000004/amzn-
20221231.htm Raghunath, A. (2023, November 23). Can amazon stock (NASDAQ:AMZN) reach record highs in 2024?
. Nasdaq. https://www.nasdaq.com/articles/can-amazon-stock-nasdaq:amzn-reach-
record-highs-in-2024
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
Q4
Costs:
LayoffHiringInventory
Totals: 246 246 30,000
Costs: $246,000 $492,000 $30,000
Cost of plan:$768,000
Planning values
Starting inventory: 2,500
Starting and ending workforce: 200
Hours worked per month per hour: 360
Hours per unit: 40
Hiring cost per worker: $2,000
Layoff cost per worker: $1,000
Monthly per-unit holding cost: $1
Forecasted sales:Month Forecasted salesMarch 1,827April 1,620May 1,440June 1,179July 1,611August 2,115September 2,637October 2,502November 3,150December 3,231January 2,826February 2,331
arrow_forward
QUESTION 2
ID11
What is an information system for identifying and planning the enterprise-wide resources needed to take, make, ship, and account for
customer orders?
BOM
MRP
CIM
ⒸERP
arrow_forward
3. Your independent oil and gas company is considering the purchase at time zero of a
100 % working interest in a property. If you elect to develop the lease for an 87.5%
revenue interest, the following costs will be incurred: in time zero, the lease bonus
cost is $100,00o, intangible drilling costs are estimated at $550,000 while tangible
completion costs are estimated at $300,000. Operating costs are estimated to
remain constant at $8.00 per barrel (includes production costs, severance taxes and
ad-valorem taxes) in each of years 1, 2, 3 and 4. Oil prices are forecasted to be
$50.00 per barrel in each of years 1, 2, 3, and 4. Production is summarized in the
following table. The escalated dollar minimum rate of return is 12.0%. Use net
present value analysis to determine if the acquisition and development of this lease
is economically viable: (a) Before considering income taxes, (b) Assuming income
tax rate of 30%. (Expense 100% of intangible drilling costs at the end of first year,…
arrow_forward
Identify and formulate requirements and constraints for the online car rental system described below. Also provide priority weights for the requirements according to the nature of the car rental business:
CAR RENTAL SYSTEM •
A car rental company operates a number of rental locations throughout the metropolitan area.
Since the company has a great business model and provides customer-friendly service, its business has boomed over the last several years. As the business has grown rapidly, the costs of running its business has also increased. In particular, as the job market becomes hot, the labor cost has doubled over the last several years. The company wants to find a solution to reduce its operating cost. The business operation of the company is described as follows. The description is not meant to be complete, and the company is flexible enough to consider any good improvement proposals.
Vehicles can be taken from one location and returned to the same…
arrow_forward
Q2. Which factors can adversely impact turn-around time as SWA? Explain comprehensively.
arrow_forward
question:
What is the amount of increase in profit for each Machine Hour added and what is the maximum number of yards that can be added for this amount of profit increase?
arrow_forward
Transcribed Image Text
On hand: 35 Planning time fence: 10 Lot size: 200 Demand time fence: 2 Period 2 4 6. 7 9. 10 11 12 Forecast 30 40 40 50 40 40 30 40 40 50 40 40 Customer Orders 31 35 29 21 17 14 33 11 5 2 Projected Available Available to Promise MPS 200 200 3.
d. Sales has requested that you add an MPS of 200 in period 9 to cover their needs for a sales promotion. What do you tell them and why?e. What action (if any) should be taken in period 11? Why is it okay to take theaction?
I only need question D and E answered
arrow_forward
2.
arrow_forward
Assignment Question !
Supplying customization places a high demand on CRM system. Discus
(4) separate approaches of mass customization. Discuss the implication
customization approaches for an organization.
arrow_forward
Data of activities and weekly delivery costs
Date
Miles Driven
Packages Delivered
Delivery Stops
Delivery Cost
1/1
2,656
15,700
12,175
$ 5,479
1/8
2,085
12,756
9,019
4,608
1/15
2,719
17,555
12,358
5,428
1/22
2,998
18,547
12,507
5,826
1/29
3,655
13,030
12,476
4,846
2/5
2,650
18,355
9,910
4,250
2/12
2,829
16,719
11,906
5,073
2/19
2,056
17,751
10,833
4,668
2/26
2,890
19,379
9,883
4,841
3/5
2,341
15,542
10,184…
arrow_forward
Question 4
b) Company ABC wishes to evaluate whether to produce a component
internally or purchase from a vendor. The firm has the following options:
Internal Production
Process 1
Process 2
Purchase from Vendor
Vendor 1
Vendor 2
Vendor 3
Variable cost of $17 per unit; annual
fixed cost of $200,000
Variable cost of $14 per unit; annual
fixed cost of $240,000
Offers a price of $20 per unit for any
volume up to 30,000 units
Offers a price of $22 per unit for 1,000
units or less, and $18 per unit for
large quantities
Offers a price of $21 per unit for the
first 1,000 units and $19 per unit for
additional units
If the annual demand is 10,000 units, which alternative would be best from
a cost standpoint? For 20,000 units, which alternative would be best?
arrow_forward
3) Amelia Ltd. makes a plastic tricycle that is composed of three major components: a handlebar-front wheel-pedal assembly, a seat and frame unit, and rear wheels. The company has orders for 48,000 of these trikes. Current schedules yield the following information. Requirements Cost to Cost to Component Plastic Time Space Manufacture Purchase Front 12 40 8 16 24 Seat/Frame 16 24 8 12 18 Rear wheel (each) .20 8 .4 2 6 Available 100000 320000 60000 The company obviously does not have the resources available to manufacture everything needed for the completion of 24000 tricycles so has gathered purchase information for each component. Develop a linear programming model to tell the company how many of each component should be manufactured and how many should be purchased in order to provide 24000 fully completed tricycles at the minimum cost.
arrow_forward
QUESTION 4
a) Assess and discuss the benefits of in-house vs. contracting out maintenance works in
term of effectiveness and resource allocation.
b) Explain and discuss the concept of Log-Out Tag-Out (LOTO) to reduce safety incidence
during maintenance works.
arrow_forward
question:
How much profit is added if you are given an additional 50 Yards of Material?
arrow_forward
Question 2
What is the throughput time of a typical pallet?
a. 222 minutes
b. 90 minutes
c. 10 minutes
d. 210 minutes
e. Impossible to determine
arrow_forward
Q4. What are the important long-term issues relevant for managing capacity, revenue, and customer satisfaction for SWA? Explain comprehensively.
arrow_forward
3) Amelia Ltd. makes a plastic tricycle that is composed of three major components: ahandlebar-front wheel-pedal assembly, a seat and frame unit, and rear wheels. Thecompany has orders for 48,000 of these trikes. Current schedules yield thefollowing information.
Requirements
Component
Plastic
Time
Space
Cost to
Manufacture
Cost to
Purchase
Front seat /Frame Rear wheel (each)
12
16
.20
40
24
8
8
8
.4
16
12
2
24
18
6
Available
100000
320000
60000
The company obviously does not have the resources available to manufactureeverything needed for the completion of 24000 tricycles so has gathered purchaseinformation for each component. Develop a linear programming model to tell thecompany how many of each component should be manufactured and how manyshould be purchased in order to provide 24000 fully completed tricycles at theminimum cost.
arrow_forward
Q1.) List and explain in detail about airline business models.
NO COPY PASTE FROM INTERNET, WRITE IT IN YOUR OWN WORDS
arrow_forward
Problem 1
The following information applies to the City View Restaurant.
May 1 Food inventory value:
$73,480 bnl
de
May 31 Food inventory value:
$77,550
bonen
Cost of food used during May
$386,410
1. What is the inventory turnover rate for food products for the City View Restaurant?
2. What does the answer (inventory turnover ratio) in question 1 mean?
arrow_forward
2 ERP articles review.
arrow_forward
Discuss the various uses for break-even analysis. (paragraph)
arrow_forward
Complete the following:
• Lead time = 1 week
•
Demand Time Fence is at the end of Week #2
MPS Lot Size = 60
On-Hand is 40
Forecast
Customer Orders
PAB
MPS
ATP
1
40
2
35
38 43
3
37
37
Week
4
29
32
S
41
31
6
52
26
arrow_forward
QUESTION 1
A master production schedule shows the following information
MPS
Week
Week
Week
Week
Beginning inventory =
300
31
Forecast
1.000
1,200
1,300
1.200
800
700
Actual customer orders
Projected on-hand
inventory
Available to promise
800
1,000
MPS
Based on the information in the MPS, what is the amount that is available to promise in week 4?
O a. 1,200
Ob.700
Oc. 1.500
O d. 500
arrow_forward
Course: Operations Management
Hotel ComplaintsA luxury hotel has been receiving a lot of complaints from guests recently. The manager worries that if these complaints continue, the hotel will start to lose clients. Therefore, you have been hired as a consultant to correct the problem(s). A list of the major complaints by week for the last month is as follows:
Complaint Number of Occurrences
Week 1Error on bill 10Room not ready at check-in 8Room service delivery late 3Longline at check-out 10
Week 2Error on bill 12Noise in hallway 2Longline at check-out…
arrow_forward
Course: Operations Management
Hotel ComplaintsA luxury hotel has been receiving a lot of complaints from guests recently. The manager worries that if these complaints continue, the hotel will start to lose clients. Therefore, you have been hired as a consultant to correct the problem(s). A list of the major complaints by week for the last month is as follows:Complaint Number of Occurrences
Week 1Error on bill 10Room not ready at check-in 8Room service delivery late 3Longline at check-out 10
Week 2Error on bill 12Noise in hallway 2Longline at check-out…
arrow_forward
Course: Operations Management
Hotel ComplaintsA luxury hotel has been receiving a lot of complaints from guests recently. The manager worries that if these complaints continue, the hotel will start to lose clients. Therefore, you have been hired as a consultant to correct the problem(s). A list of the major complaints by week for the last month is as follows:Complaint Number of Occurrences
Week 1Error on bill 10Room not ready at check-in 8Room service delivery late 3Longline at check-out 10
Week 2Error on bill 12Noise in hallway 2Longline at check-out…
arrow_forward
QUESTION THREE
Mulungushi textiles during its peak days used to manufacture gowns on a produce-to-order
basis. The company manufactured three models of gowns on the same final assembly line. The
final assembly had 20,000 hours of weekly capacity. The 6-week MPS and the final assembly
standard for each model are shown below:
Final Assembly Standard
Weekly Production (Gowns)
Product
(hours per gown)
| 2
4
|5
1
3
6
200 150
200
| 250 150 250
A
25
B.
30
100 200
350
250
150
250
35
|150 150 150
250
|250
200
a) Compute the actual final assembly hours required at the plant in each week and for
the total 6 weeks to produce the MPS. Compare the load to the labour-hours
capacity in each week and for the total 6-weeks.
b) Does enough production capacity exist to produce the MPS?
c) What changes to the MPS would you recommend?
arrow_forward
Briefly define or explain each of these terms:d. Gross requirements
arrow_forward
Product (ice cream) demand feasibility?
arrow_forward
QUESTION 2
When used effectively, S&OP Planning does not require cross-functional collaboration.
O True
False
arrow_forward
Bill of Material for Office Table
Top Assembly
(1 required)
Bracket
(required)
Office Table Final Assembly
Gross Requirements
Scheduled Receipts
Projected On-Hand Inv
Net Requirements
Planned Order Receipts
Planned Order Releases
Lead Time (in weeks)
Lot Size
Table-Top Assembly
Gross Requirements
Scheduled Receipts
Projected On-Hand Inv
Net Requirements
Planned Order Receipts
Planned Order Releases
Wood Screw
(48 required)
Lead Time (in weeks)
Lot Size
MS.53 An office furniture manufacturer needs to calculate material requirements for one of its most popular tables. The graphic above shows the bill of
material for this item. Below are the MRP tables for the top-level assembly (the Office Table Final Assembly) and one of its sub-assemblies (the Table-Top
Assembly
Final Assembly
320
1
100
130
2
50
Support Assembly
8/1
Center Support
(1 required)
150
8/1 8/8 8/15 8/22 8/29 9/5 9/12 9/19 9/26
200 200
500
300
800 400
Side Support
[2 required)
8/3 8/15
315 3/12 9/19 3/26
For the Office Table…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Related Questions
- Q4 Costs: LayoffHiringInventory Totals: 246 246 30,000 Costs: $246,000 $492,000 $30,000 Cost of plan:$768,000 Planning values Starting inventory: 2,500 Starting and ending workforce: 200 Hours worked per month per hour: 360 Hours per unit: 40 Hiring cost per worker: $2,000 Layoff cost per worker: $1,000 Monthly per-unit holding cost: $1 Forecasted sales:Month Forecasted salesMarch 1,827April 1,620May 1,440June 1,179July 1,611August 2,115September 2,637October 2,502November 3,150December 3,231January 2,826February 2,331arrow_forwardQUESTION 2 ID11 What is an information system for identifying and planning the enterprise-wide resources needed to take, make, ship, and account for customer orders? BOM MRP CIM ⒸERParrow_forward3. Your independent oil and gas company is considering the purchase at time zero of a 100 % working interest in a property. If you elect to develop the lease for an 87.5% revenue interest, the following costs will be incurred: in time zero, the lease bonus cost is $100,00o, intangible drilling costs are estimated at $550,000 while tangible completion costs are estimated at $300,000. Operating costs are estimated to remain constant at $8.00 per barrel (includes production costs, severance taxes and ad-valorem taxes) in each of years 1, 2, 3 and 4. Oil prices are forecasted to be $50.00 per barrel in each of years 1, 2, 3, and 4. Production is summarized in the following table. The escalated dollar minimum rate of return is 12.0%. Use net present value analysis to determine if the acquisition and development of this lease is economically viable: (a) Before considering income taxes, (b) Assuming income tax rate of 30%. (Expense 100% of intangible drilling costs at the end of first year,…arrow_forward
- Identify and formulate requirements and constraints for the online car rental system described below. Also provide priority weights for the requirements according to the nature of the car rental business: CAR RENTAL SYSTEM • A car rental company operates a number of rental locations throughout the metropolitan area. Since the company has a great business model and provides customer-friendly service, its business has boomed over the last several years. As the business has grown rapidly, the costs of running its business has also increased. In particular, as the job market becomes hot, the labor cost has doubled over the last several years. The company wants to find a solution to reduce its operating cost. The business operation of the company is described as follows. The description is not meant to be complete, and the company is flexible enough to consider any good improvement proposals. Vehicles can be taken from one location and returned to the same…arrow_forwardQ2. Which factors can adversely impact turn-around time as SWA? Explain comprehensively.arrow_forwardquestion: What is the amount of increase in profit for each Machine Hour added and what is the maximum number of yards that can be added for this amount of profit increase?arrow_forward
- Transcribed Image Text On hand: 35 Planning time fence: 10 Lot size: 200 Demand time fence: 2 Period 2 4 6. 7 9. 10 11 12 Forecast 30 40 40 50 40 40 30 40 40 50 40 40 Customer Orders 31 35 29 21 17 14 33 11 5 2 Projected Available Available to Promise MPS 200 200 3. d. Sales has requested that you add an MPS of 200 in period 9 to cover their needs for a sales promotion. What do you tell them and why?e. What action (if any) should be taken in period 11? Why is it okay to take theaction? I only need question D and E answeredarrow_forward2.arrow_forwardAssignment Question ! Supplying customization places a high demand on CRM system. Discus (4) separate approaches of mass customization. Discuss the implication customization approaches for an organization.arrow_forward
- Data of activities and weekly delivery costs Date Miles Driven Packages Delivered Delivery Stops Delivery Cost 1/1 2,656 15,700 12,175 $ 5,479 1/8 2,085 12,756 9,019 4,608 1/15 2,719 17,555 12,358 5,428 1/22 2,998 18,547 12,507 5,826 1/29 3,655 13,030 12,476 4,846 2/5 2,650 18,355 9,910 4,250 2/12 2,829 16,719 11,906 5,073 2/19 2,056 17,751 10,833 4,668 2/26 2,890 19,379 9,883 4,841 3/5 2,341 15,542 10,184…arrow_forwardQuestion 4 b) Company ABC wishes to evaluate whether to produce a component internally or purchase from a vendor. The firm has the following options: Internal Production Process 1 Process 2 Purchase from Vendor Vendor 1 Vendor 2 Vendor 3 Variable cost of $17 per unit; annual fixed cost of $200,000 Variable cost of $14 per unit; annual fixed cost of $240,000 Offers a price of $20 per unit for any volume up to 30,000 units Offers a price of $22 per unit for 1,000 units or less, and $18 per unit for large quantities Offers a price of $21 per unit for the first 1,000 units and $19 per unit for additional units If the annual demand is 10,000 units, which alternative would be best from a cost standpoint? For 20,000 units, which alternative would be best?arrow_forward3) Amelia Ltd. makes a plastic tricycle that is composed of three major components: a handlebar-front wheel-pedal assembly, a seat and frame unit, and rear wheels. The company has orders for 48,000 of these trikes. Current schedules yield the following information. Requirements Cost to Cost to Component Plastic Time Space Manufacture Purchase Front 12 40 8 16 24 Seat/Frame 16 24 8 12 18 Rear wheel (each) .20 8 .4 2 6 Available 100000 320000 60000 The company obviously does not have the resources available to manufacture everything needed for the completion of 24000 tricycles so has gathered purchase information for each component. Develop a linear programming model to tell the company how many of each component should be manufactured and how many should be purchased in order to provide 24000 fully completed tricycles at the minimum cost.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- BUSN 11 Introduction to Business Student EditionBusinessISBN:9781337407137Author:KellyPublisher:Cengage LearningEssentials of Business Communication (MindTap Cou...BusinessISBN:9781337386494Author:Mary Ellen Guffey, Dana LoewyPublisher:Cengage LearningAccounting Information Systems (14th Edition)BusinessISBN:9780134474021Author:Marshall B. Romney, Paul J. SteinbartPublisher:PEARSON
- International Business: Competing in the Global M...BusinessISBN:9781259929441Author:Charles W. L. Hill Dr, G. Tomas M. HultPublisher:McGraw-Hill Education
BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education