BSBFIM501 Project Steps 1,2 4 Excel Assessment Template V1.0819

xlsx

School

Universal Business School Sydney *

*We aren’t endorsed by this school

Course

311

Subject

Business

Date

Nov 24, 2024

Type

xlsx

Pages

6

Uploaded by Musika

Report
2018-19 2019-20 2020-21 2021-22 2022-23 Income 150,000,000 172,500,000 198,375,000 228,131,250 262,350,937 Expenditure 127,500,000 146,725,000 168,618,750 193,875,000 222,998,297 Profit 22,500,000 25,775,000 29,756,250 34,256,250 39,352,640 Reinvest 16,875,000 19,331,250 22,317,188 25,692,188 29,514,480 2018-19 2019-20 2020-21 2021-22 2022-23 0 50,000,000 100,000,000 150,000,000 200,000,000 250,000,000 300,000,000 Finance Budget
Income Expenditure Profit Reinvest
SALES DATA PREVIOUS QUARTER Product Price/unit Quantity Sales Widgets $ 30.00 5000 $ 150,000 $ 150,000 Zings $ 100.00 12500 $ 1,250,000 $ 1,000,000 Zacs $ 200.00 3750 $ 750,000 $ 750,000 Hools $ 70.00 7500 $ 525,000 $ 787,500 Pings $ 10.00 2525 $ 25,250 $ - Nocs $ 150.00 2500 $ 375,000 $ 375,000 Beels $ 100.00 8750 $ 875,000 $ 875,000 Total $ 3,950,250 $ 3,937,500 Target $ 4,542,788 Shortfall based on above calculations $ 605,288 Total of unchanged items $ 2,150,000 0.13 28.15% Revised sales figures a provid
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
FORECAST FOR NEXT QUARTER Revised sales figures to meet target Quantity $ 192,229 28.15% 6,407.63 20% down $ 1,000,000 -20% 10,000.00 $ 961,147 28.15% 4,805.74 50% up $ 787,500 50% 11,250.00 removed from sale $ - Removed - $ 480,573 28.15% 3,203.82 $ 1,121,338 28.15% 11,213.38 15% $ 4,542,788 115.00% against information ded These items sales must increase by an extra28.152907 % to meet shortfall of 605,288 and meet revised target
SALES DATA PREVIOUS QUARTER Product Price/unit Quantity Sales Widgets $ 30.00 5000 $ 150,000 $ 150,000 Zings $ 100.00 12500 $ 1,250,000 $ 1,000,000 Zacs $ 200.00 3750 $ 750,000 $ 750,000 Hools $ 70.00 7500 $ 525,000 $ 707,000 Pings $ 10.00 2525 $ 25,250 $ - Nocs $ 150.00 2500 $ 375,000 $ 375,000 Beels $ 100.00 8750 $ 875,000 $ 875,000 Total 42525 $ 3,950,250 $ 3,857,000 Target $ 4,542,788 Shortfall $ 685,788 Total of unchanged items $ 2,150,000 Contingency budget $ 2,835,788 Calculations of Hools sales based on ? 1.31897093023256 Quantity sold per month based on previous quarter: ? Price/unit Quantity Sales Comment Month 1 $ 70.00 3250 $ 227,500 Up 30% Month 2 $ 70.00 3250 $ 227,500 Up 30% Month 3 $ 63.00 4000 $ 252,000 Up 60% w/Price reduction TOTAL $ 10500 $ 707,000 Revised sales figures ag provide
FORECAST FOR NEXT QUARTER Revised sales figures to meet target Quantity 0% $ 197,846 31.90% 0 0.319 -20% $ 1,000,000 -20% - 0 0 $ 989,228 31.90% 0 35% $ 707,000 35% 10,500 Removed - Removed 0% $ 494,614 31.90% 0 0% $ 1,154,100 31.90% 0 $ 4,542,788 gainst information ed
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 Documents

swot_project_final_form.pptx
Order 6265249.docx
MEMO.docx
LOPEZ_MAYRA_U4T1.docx
Revised 2405ASQIQBCSTRETHICSF1000.docx
BUS 400 Module Six Assignment.docx
Week 3Z Policy Mandates US vs European Approaches to Privacy Laws.docx
HCD402 – Human Centered Design- Revised.pptx
Quiz 9 (page 2 of 2).pdf
Email Letter Response.docx
Technological Solutions (2).docx
Document1.docx
Recommended textbooks for you
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Text book image
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L
Text book image
Principles of Management
Management
ISBN:9780998625768
Author:OpenStax
Publisher:OpenStax College
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Foundations of Business (MindTap Course List)
Marketing
ISBN:9781337386920
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning
Text book image
Foundations of Business - Standalone book (MindTa...
Marketing
ISBN:9781285193946
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Text book image
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L
Text book image
Principles of Management
Management
ISBN:9780998625768
Author:OpenStax
Publisher:OpenStax College
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Foundations of Business (MindTap Course List)
Marketing
ISBN:9781337386920
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning
Text book image
Foundations of Business - Standalone book (MindTa...
Marketing
ISBN:9781285193946
Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:Cengage Learning
SEE MORE TEXTBOOKS