Prepare the annual budget for 2022

Assignment Help Managerial Accounting
Reference no: EM132973383

ACCT6002 Managerial Accounting

You are a managerial accountant that has been hired by the owner and founder of The Cork Shop1, Byron Bay, to prepare the annual budget for 2022 and to make recommendations for improving its operations.

As per their company website "cork is an amazing raw material, harvested from the Cork Oak tree (Quercus Suber) without damaging the tree. In fact, no trees are ever cut down as only the bark is carefully removed. Harvesting helps regenerate the trees, contributing to their thriving life span of more than 200 years."

Cork is sustainable, 100% vegan, durable, recyclable and eco-friendly. Cork is also free from plastics, rubber and latex. It is not affected by mould, as it is moisture resistant. Due to Cork's unique properties, this is why it has been chosen as the material to manufacture their purses and wallets.

REQUIRED:

PART ONE:

Prepare a Master Budget

Using the information provided, prepare a master budget for The Cork Shop for the twelve- month period from January 2022 to December 2022 to produce and sell the three product outlined.
Your budget spreadsheet must be submitted in Excel Format (not as an appendix in your WORD document). The first worksheet should contain the budget assumptions. All future worksheets need to be linked to this data. Show all calculations and use Excel functions where possible. While you should use examples in your text as a guide, the key to using spreadsheets is that they are structured so that others can use them and follow the flow of information without difficulty.
Include the following:

1. A sales budget and expected cash collections
2. A production budget
3. A direct materials budget and expected cash disbursements for purchases of materials
4. A direct labour budget
5. A manufacturing overhead budget
6. Monthly Operating Cost budget
7. An ending finished goods inventory budget
8. Cost of Sales Budget
9. Budgeted Income Statement for the year ended 31st Dec 2022
10. Monthly Cash Budget

All of the planning and budgeting assumptions for the year have been provided to you in a budget template ready for you to use to prepare the Master Budgets. Please find these budget assumptions ACCT6002 S2 2021 The Cork Shop Budget.xls file in the Major assignment folder on Black Board. Use this excel file to complete this section of your assignment.

PART TWO:

Analysis & Recommendations

Write a report (Maximum 1,500 words, 10% (+/-) will be accepted with no penalty) for the owner of The Cork Shop.

The report should include:

- An overview of the expected results for the 2022 year including total revenue, operating expenses and expected final cash position;
- Compare the financial performance of each product and make recommendations about how to improve the individual and overall profitability of the sustainable products range. Where appropriate use industry data (e.g. comparative product comparison, consumer confidence, labour rates) to support your recommendations for change.
- Identify three major risks for the business in 2022, quantify these risks in terms of the potential impact on the profit and loss statement and provide recommendations on how to mitigate them.
- Explain how the master budget you have prepared can assist The Cork Shop to plan for different ‘what-if' scenarios and help them to pivot according to changes in economic conditions.
- Use visual aids such as tables and graphs to enhance your report presentation.

Attachment:- Managerial Accounting.rar

Reference no: EM132973383

Questions Cloud

Calculate the amount that each partner will receive : Calculate the amount that each partner will receive in each of the following situations: a) Net Income of $145 000. b) Net Income of $78 000
Stage between sleep and wakefulness : Sleep inertia is a stage between sleep and wakefulness. Sleep inertia troubles many people. When they want to sleep it is difficult to fall asleep or when they
Show an extract of the statement of financial position : Show an extract of the statement of financial position on completion of the issue. Heri ltd was incorporated in 2016 with authorized share capital of 8,000,000.
Find company ev-book value of capital ratio : A corporation has an ROC of 15%, debt-equity ratio of 1/3, after-tax cost of debt of 6%, cost of equity of 18%, a reinvestment rate of 33.33% and an after-tax o
Prepare the annual budget for 2022 : Prepare a Master Budget - direct materials budget and expected cash disbursements for purchases of materials - overview of the expected results for the 2022
What is the price you would be willing to pay : What is the price you would be willing to pay for a bond with a coupon rate of 5%, interest paid semiannually, a maturity value of $1000
Prepare marginal costing income statements for quarters : The fixed production costs per year amounted to $150,000. Prepare marginal costing income statements for all four quarters of 2020.
Which type of risk is this company facing in this case : A company operating in Japan must pay 6 million euros for products that will be received in France within one month. Which type of risk is this company facing
How social structures affect people lives : Explain how social structures affect people's lives.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd