please answer. Also make a master budget including 10 budgets.

Thankyou

ACCT 3010 Mid-term Project \& Presentation Fall 2022 - 30Ni of final grade - Report is due in D2L Dropbox on Sunday September 420 at 4.00pm - Presentation will start on 5 unday 5eptember 4 at 400pm groups will be chosen to present randomly - Presentations maximum 15 minutes. - All group members are required to present information relevant to the tasks during t' presentation - Late assignments will not be accepted Required fead the information provided. Prepare a 12 to 15 pages report that will include the following: Using excel, prepare a master budget for the Poster Company using the information provided (10 sheets in excel) V Prepare an anafysis using cost volume profit anahysis, including items such as breakeven, revenue, costs and operating leverage, to jutify your decisions in your maste budget Prepare a master budget with 10 budgets including income statement and balance sheet - Explain the cost estimation techniques yoa used and why - Explain any assumptions you have made regarding the company and industry V Prepare a 10-15 minute presentation, Where all members must speak, Reference materials must be cited using APA Prepare a 10 to 15 minute presentation to the owner of the Paster Company explaining ti budget decisions and outcomes. Situstion Your team has been hired by the Poster company to prepare their 2025 master budget. You have been provided with the current year actuaks. Assumptiors - Cuerent year project irflation 20 . - 2023 project inflation 3\%. - Salary hicreases are scheduled to be 15\%. These will coly happen if the Poster Company. has a profit. - Would like to hire an additional production assistant for 046.000/ month plus benefits. - Ending imventory is estimated to be 201s of the next in onth's sale. - Materials are purchased with cash 25% and on credie 75\%5 - Credit payments are as follows 30% in the month of saie and 7 ur the following manth. - Sales are 100% on cash and credit card. - There is a line of uredit up to QAR. 50,000 and the interest is 3.0%5 - The owner could provide an additional 0 AR 100,000 of capital if fequired. asks - Prepare a cost-wolume profit analysis to determine price or prices or units need to be increased. - Using excel, prepare a master budget with supporting calculations. - You will need to explain what cost estimation techique you used and why. - Prepare a 12 - 15 page report with cover page, heading and references. - Prepare a 101015 minute presentation on your budget for the owner. vestions to consider. - What are the advantages and disadvantages of the technique you used? - Perform a cost volume profit analysis that justifies your master budget. - Do you necd to increase the selling price? * Does yeur volume need to increase or decrease in order to make an operating income? Purpose: Krowledge: This project will help you demonstrate your undersanding of stratedic cost management is and how to use cost estimation techniques to prepare a master budeet and conduct CVP analysis. CLO1: Explain strategic cost management CL02: Calculate forecased cost and profit and develop all budgets a part of the budgeting process sills The purpose of this mid term project is to help you dementrate your understanding and application of the following - Cto 1 Strategic cost management - clo1 issues in the current business environment - ClO2 Use and explain cost estimation techniques to predict future costs - ClO2 Use and explain CVP to analyre short-term profits - ClO2 Create a master budget - Use of excel - Presentation skalls 1 Introduction to the Poster Compary cards. Our desers are dae of a hind company and are profoced in smal batches at ear printing faclity. The art shint and posters are printed on hid euter archini poser to reduct color tading. We seil out pros acts le owr ene tecall locatign. 1.1 Prodocts Art prints, wrappirs pepet, carats. posteardh isurnals 1.2 industry Deven Printise Retail Touritm 1.4 Stratesv To provide *igh qualty one of a wad art seints for the local and insernational warket that we preduced Qatar. We do this by devgring unique desids latpired by the local eswironment. We use hich qualty archival paser, inls and printing techoologr. We sell our prodocts in aur shod. 15 Future Imolve more lacai designer and artists 10 scovide one of a kind artwork for art pripts, postees and cards so seit Expand to two add tional retarlocarion with high tourat visits. Papercampany, Fiancalart2022. 5urtmary? interest Expense 273 -1n Papticompany, finandahal 2022 is Paperdompeny_Tenciala 3022 Captal ACCT 3010 Mid-term Project \& Presentation Fall 2022 - 30Ni of final grade - Report is due in D2L Dropbox on Sunday September 420 at 4.00pm - Presentation will start on 5 unday 5eptember 4 at 400pm groups will be chosen to present randomly - Presentations maximum 15 minutes. - All group members are required to present information relevant to the tasks during t' presentation - Late assignments will not be accepted Required fead the information provided. Prepare a 12 to 15 pages report that will include the following: Using excel, prepare a master budget for the Poster Company using the information provided (10 sheets in excel) V Prepare an anafysis using cost volume profit anahysis, including items such as breakeven, revenue, costs and operating leverage, to jutify your decisions in your maste budget Prepare a master budget with 10 budgets including income statement and balance sheet - Explain the cost estimation techniques yoa used and why - Explain any assumptions you have made regarding the company and industry V Prepare a 10-15 minute presentation, Where all members must speak, Reference materials must be cited using APA Prepare a 10 to 15 minute presentation to the owner of the Paster Company explaining ti budget decisions and outcomes. Situstion Your team has been hired by the Poster company to prepare their 2025 master budget. You have been provided with the current year actuaks. Assumptiors - Cuerent year project irflation 20 . - 2023 project inflation 3\%. - Salary hicreases are scheduled to be 15\%. These will coly happen if the Poster Company. has a profit. - Would like to hire an additional production assistant for 046.000/ month plus benefits. - Ending imventory is estimated to be 201s of the next in onth's sale. - Materials are purchased with cash 25% and on credie 75\%5 - Credit payments are as follows 30% in the month of saie and 7 ur the following manth. - Sales are 100% on cash and credit card. - There is a line of uredit up to QAR. 50,000 and the interest is 3.0%5 - The owner could provide an additional 0 AR 100,000 of capital if fequired. asks - Prepare a cost-wolume profit analysis to determine price or prices or units need to be increased. - Using excel, prepare a master budget with supporting calculations. - You will need to explain what cost estimation techique you used and why. - Prepare a 12 - 15 page report with cover page, heading and references. - Prepare a 101015 minute presentation on your budget for the owner. vestions to consider. - What are the advantages and disadvantages of the technique you used? - Perform a cost volume profit analysis that justifies your master budget. - Do you necd to increase the selling price? * Does yeur volume need to increase or decrease in order to make an operating income? Purpose: Krowledge: This project will help you demonstrate your undersanding of stratedic cost management is and how to use cost estimation techniques to prepare a master budeet and conduct CVP analysis. CLO1: Explain strategic cost management CL02: Calculate forecased cost and profit and develop all budgets a part of the budgeting process sills The purpose of this mid term project is to help you dementrate your understanding and application of the following - Cto 1 Strategic cost management - clo1 issues in the current business environment - ClO2 Use and explain cost estimation techniques to predict future costs - ClO2 Use and explain CVP to analyre short-term profits - ClO2 Create a master budget - Use of excel - Presentation skalls 1 Introduction to the Poster Compary cards. Our desers are dae of a hind company and are profoced in smal batches at ear printing faclity. The art shint and posters are printed on hid euter archini poser to reduct color tading. We seil out pros acts le owr ene tecall locatign. 1.1 Prodocts Art prints, wrappirs pepet, carats. posteardh isurnals 1.2 industry Deven Printise Retail Touritm 1.4 Stratesv To provide *igh qualty one of a wad art seints for the local and insernational warket that we preduced Qatar. We do this by devgring unique desids latpired by the local eswironment. We use hich qualty archival paser, inls and printing techoologr. We sell our prodocts in aur shod. 15 Future Imolve more lacai designer and artists 10 scovide one of a kind artwork for art pripts, postees and cards so seit Expand to two add tional retarlocarion with high tourat visits. Papercampany, Fiancalart2022. 5urtmary? interest Expense 273 -1n Papticompany, finandahal 2022 is Paperdompeny_Tenciala 3022 Captal