Prepare budgeted income statement

Assignment Help Managerial Accounting
Reference no: EM132641406

Case Study - Master Budget, Cash Budget and Budgeted Income Statement

After two years study at UCW, you finally graduate and start a job as Junior accountant at All About The BeardInc.(AATB). Your manager is responsible for the national distribution of men grooming sets. Because of the new fashion style among current generation, the company has grown rapidly, and the prompt growth forces the management team to improve their efficiency and manage their production effectively.

You have just been given responsibility for all planning and budgeting of the entire men grooming set division. Today is your first day, you have just given an assignment to prepare master budget for the manager, who needs to present the budget and discuss the financial objectives with the shareholders tomorrow. During your job interview, you clearly stated that you gained managerial accounting knowledge and hand on experience during your MBA study.

Your first assignment is to prepare a master budget for the next fiscal year, starting October1, 2020. The office managerbrought a pile of files on your desk including the past sale records, product information, manufacture schedule and supplier pricing list. Now, you realized that you should have pay more attention during the lecture rather than checking your social media page. Now, you don't know where to start. Fortunately, you remember that you still kept a copy spreadsheet of the master budget template in your computer from the accounting course during your MBA study.

Note: The company desires a minimum ending cash balance each month on $35,000. The beard grooming products are sold to retailers for $20 each and the sales have been stagnant due to the Covid-19. However, the marketing department has been positive toward the end of the year due to season change and upcoming holiday. The marketing department has just sent you their forecasted quarter sales and marketing budget.

Quarter

2020 Q4

2021 Q1

2021 Q2

2021 Q3

2021 Q4

2022 Q1

Sales in Unit

30,000

35,000

40,000

65000

68000

70,000

Marketing Expenses

$35,000

$20,000

$20,000

$45,000

$45,000

$45,000

The increased sales volume before and during June and January is due to Father's Day and holidays with AATB being a favorite. Ending finished goods inventories are supposed to be equal to 20% of the next month's sales in units. AATB currently does its own assembly production in house. Each unit consists of 3 shaves and the cost of each is $1.50. Each unit needs 0.10 labour hour from assemble to finish package. The hourly pay rate to the assembling workers is $15 per hour. The production manager also required desired direct material ending inventory to 30% of the next quarter production.

Purchases are paid for in the following manner: 50% in the quarter of the purchase and the remaining 50% paid in the quarter following the purchase. All sales to the distributors are made on credit terms with no discount (for now), and payable within 15 days. The AATB has determined that only 50% of sales are collected by the end of the quarter in which the sale occurred. An additional 30% is collected in the quarter following the sale, and the remaining 20% is collected in the second quarter following the sale. Bad debts have been negligible, supporting the credit terms as favorable.

Below is a display of the AATB division monthly manufacture overhead and selling and administrative expenses:Manufacture Overhead
Variable:
Indirect labour $0.5 per labour hour
Indirect Materials $0.2 per labour hour

Fixed:
Wages and Salaries$2,000 per month
Utilities $1,500 per month
Insurance $2,000 per month
Depreciation $2,000 per month

Selling and Administrative
Variable:
Sales Commissions $1 per unit
Fixed (Monthly) :
Wages and Salaries$22,000
Utilities $6,000
Insurance $1,200
Depreciation $1,500
Miscellaneous $3,000
Labour, Manufacture Overhead, and Selling and Administrative expenses are all paid during the month, in cash, with the exception of depreciation (of course). AATB will make a purchase of a parcel of land during the quarter of 2021 for $22,500 cash. AATB contributes to the corporate dividend at a rate of $12,000 each quarter, payable in the first month of the following quarter. AATB's balance sheet at the end of the first quarter is shown below:
Assets
Cash $14,000
Accounts receivable ($48,000 sales in Q2 and $152,000 in Q3 this year ) $200,000
Liabilities
Accounts payable $85,700

An agreement with Bank of the West allows AATB to borrow in increments of $1,000 at the beginning of each month, up to a total loan amount of $550,000. The interest rate on these loans is 12% annually (pretty high considering market rates) but the interest is not compounded, meaning this is simple interest only.

Required:
Prepare a master budget for twelve months from Oct, 2020 to Oct, 2021. Include the following budget schedules and financial statements:
1) Master Budget
2) Cash Budget. Show the cash budget by month and in total.
3) Budgeted Income statement

Reference no: EM132641406

Questions Cloud

Show a comprehensive example with a hypothetical dataset : With reference to the ISIC, design a coding system to record the major agriculture sector outputs in your country. Show a comprehensive example with a hypotheti
Demonstrate thoughtful consideration of the ideas : For this task, imagine that you are assigned to a case of a known pedophile. He/she has been arrested after sexually perpetrating a 6-year-old boy.
Evaluate touchdown sports inc decision to use the eoq : Critically evaluate Touchdown Sports Inc's decision to use the EOQ model as part of its approach to the management of inventories.
Describe reasons for the implementation of probation : What were the original reasons for the implementation of probation and parole? Do those reasons still apply today-why or why not?
Prepare budgeted income statement : Master Budget and Cash Budget. Show the cash budget by month and in total - Budgeted Income statement
Define what constitutional issues might arise during trial : Assume you are a judge in state court presiding over a high-profile criminal case in which the governor, who is married and has five children, allegedly killed.
How do determine what is the journal entry : January 31, 2016 check is dishonored and the contract is settled on this date, in accordance with the terms of the contract. what is the journal entry?
Contrast propeller driven performance in an aircraft : Compare and contrast propeller driven performance in an aircraft.
Prepare a master budget for twelve months : Prepare a master budget for twelve months from Oct, 2020 to Oct, 2021. Include the following budget schedules and financial statements

Reviews

len2641406

9/23/2020 5:31:36 AM

hey, I''m attaching assignment with a sample. I need all the exact steps that are done on sample. but I need it in a quarterly basis not monthly.

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