Reference no: EM131049054
You are the management accountant at Yin & Yang Pty Ltd. It is your job to prepare the Master budget for the next quarter
The company manufactures plastic boxes. To prepare the master budget you will need to prepare subsidiary budgets that link together to create the Income Statement and Balance Sheet for the 3 month period.
You should use Excel to prepare your budget. Each minor budget should be on a separate worksheet. Your budget should have its formulas linked so that if one or more elements change the budget can be easily amended.
The production manager has worked with you to prepare some of the variables to assist you to prepare the budgets.
Required:
Prepare the following Budgets for the months of July, August and September and for the quarter:
a) Sales Budget
b) Production Budget (in units only)
c) Materials Cost Budget
d) Wages Cost Budget
e) Production Overheads Cost Incurred Budget
f) Total Production Cost Incurred Budget (summary of budgets c, d & e)
g) Raw Materials Purchases Budget
h) Marketing and Administration Cost Budget
i) Cash Receipts Budget
j) Cash Payments Budget
k) Summary Cash Budget (summary budgets i & j)
l) Budgeted Income Statement for each month
m) Budgeted Balance Sheet for each monthBudget Preparation Data
COMPANY NAME: Yin & Yang Pty Ltd. YEAR: 2016
Months in Budget Period
i). July
ii). August
iii). September
Product Data:
Product Name Gizzmo
Standard Unit Selling Price $50.00
Standard cost Schedule for 1 unit of production
|
Raw Materials Name
|
Units
Kgs
|
Unit Price
|
Cost
|
|
Material A
|
1.0
|
$9.00
|
$9.00
|
|
Material B
|
0.5
|
$4.00
|
$2.00
|
|
Label
|
1
|
$1.00
|
$1.00
|
|
|
|
|
$12.00
|
|
Direct Labour Type
|
Hours
|
Rate per Hour
|
|
|
Processing
|
0.5
|
$16.00
|
$8.00
|
|
Finishing
|
0.4
|
$18.00
|
$7.20
|
|
|
|
|
$15.20
|
|
Variable Manufacturing Overhead
|
Hours
|
Rate per Hour
|
|
|
|
0.5
|
$5.00
|
$2.50
|
|
Fixed Manufacturing Overheads
|
Budgeted
Total
|
Normal
Output
|
|
|
|
$ per
|
Units
|
|
|
|
Month
|
per Month
|
|
|
|
$9,000
|
9,000
|
$1.00
|
|
Total Standard Cost
|
|
|
$30.70
|
|
Selling and Administration Expenses
|
|
|
|
|
Variable per unit of product sold
|
$1.00
|
|
|
|
Fixed - Total per Month
|
$15,000
|
|
|
|
Depreciation of Plant & Equipment
|
|
|
|
|
Included as part of Fixed Overhead
|
$4,000
|
|
|
|
Included as part of Selling & Administration
|
$2,000
|
|
|
|
Budget Assumptions
|
|
|
Month
|
Budgeted Sales Units
|
|
1
|
July
|
|
8,000
|
|
2
|
August
|
|
10,000
|
|
3
|
September
|
|
12,000
|
|
4
|
October
|
|
9,000
|
|
Per cent of sales collected in month of sale
|
|
25.00%
|
|
Per cent of sales collected in month after sale
|
|
73.00%
|
|
Per cent of sales treated as Bad Debts
|
|
2.00%
|
|
Finished goods as a per cent of next month's sales
|
20.00%
|
|
Raw materials as a Per cent of next month's production
|
25.00%
|
|
Raw materials purchases:
|
|
|
Per cent paid in the month of purchase
|
|
90.00%
|
|
|
Per cent paid in the month after purchase
|
10.00%
|
|
All other production costs (Labour & Overhead)
|
|
|
Per cent paid in month incurred
|
|
75.00%
|
|
|
Per cent paid in the following month
|
|
25.00%
|
|
Fixed Selling and Administration Expenses
|
|
|
All paid in the month
incurred
|
|
100.00%
|
|
Variable Selling and Administration Expenses
|
|
|
Per cent paid in the month incurred
|
|
80.00%
|
|
|
Per cent paid in the following month
|
|
20.00%
|
|
Loan Payments made
|
|
|
Payment Amount
|
|
$10,000
|
|
|
Month Paid in
|
|
September
|
|
Tax payable
|
|
|
Tax Rate
|
|
25.00%
|
|
|
Month Paid in
|
July, October, January, April
|
|
Yin & Yang Pty Ltd
Balance Sheet As at 30 June 2016
|
|
Assets:
|
|
|
|
|
Current Assets
|
|
|
|
|
Cash
|
|
|
$150,000
|
|
Accounts Receivable, Net
|
|
$160,000
|
|
Finished Goods Inventories:
|
|
Units
|
Unit Cost
|
|
|
|
1,000
|
$26.20
|
|
$26,200
|
|
Raw Materials Inventories:
|
|
|
Units
|
Value
|
|
|
Material A
|
260
|
$2,340
|
|
|
Material B
|
260
|
$1,040
|
|
|
Labels
|
260
|
$260
|
$3,640
|
|
Total Current Assets
|
|
$339,840
|
|
Non Current Assets
|
|
|
|
|
Land & Buildings
|
|
$104,000
|
|
Plant and Equipment:
|
|
Cost
|
$100,000
|
|
|
Acc Depreciation
|
$30,000
|
$70,000
|
|
Office Furniture
|
|
|
|
|
Cost
|
|
$25,000
|
|
|
Acc Depreciation
|
$5,000
|
$20,000
|
|
Total Non Current Assets
|
|
$194,000
|
|
Total Assets
|
|
|
$533,840
|
|
Liabilities
|
|
|
|
|
Current Liabilities
|
|
|
|
|
Accounts Payable (Raw Materials)
|
|
$17,200
|
|
Taxes Payable
|
|
|
$2,000
|
|
Accrued Selling & Admin Expenses
|
$3,000
|
|
Accrued Productions Costs
|
|
$27,000
|
|
Total Current Liabilities
|
|
$49,200
|
|
Non Current Liabilities
|
|
Long Term Loan
|
|
$200,000
|
|
Total Non Current Liabilities
|
|
$200 000
|
|
Total Liabilities
|
|
|
$249,200
|
|
Net Assets
|
|
|
$284,640
|
|
Owners' Equity
|
|
|
|
|
Paid Up Capital
|
|
|
$200,000
|
|
Retained Earnings
|
|
$84,640
|
|
Total Owners Equity
|
|
$284,640
|
|
Effective annual rate of interest
: Company X sells on a 2/15, net 60, basis. Customer Y buys goods with an invoice of $4,500. a. How much can company Y deduct from the bill if it pays on day 15? Discount $ b. How many extra days of credit can company Y receive if it passes up the cash..
|
|
Compare the performance of your by-hand encoder/decoder
: If possible, compare the performance of your "by-hand" encoder/decoder with the corresponding XDR routines.
|
|
Two different bonds currently outstanding
: Jallouk Corporation has two different bonds currently outstanding. Bond M has a face value of $50,000 and matures in 20 years. The bond makes no payments for the first six years, then pays $1,600 every six months over the subsequent eight years, and ..
|
|
What strategies would you like to recommend to board of lidi
: Given the changes currently taking place in the UK supermarket industry what strategies would you like to recommend to the Board of Lidl in order to improve their profitability and image with the public
|
|
Prepare the budgets for the months of july
: BAC104 Management Accounting Fundamentals - Prepare the Budgets for the months of July, August and September and for the quarter - Total Production Cost Incurred Budget
|
|
The equity for a development deal
: A developer puts in 5% equity and a fund puts in 95% of the equity for a development deal. Cash flow is to be distributed with the following order of priorities (e.g., "the waterfall"): What are the returns to the developer and the fund? What if the ..
|
|
Create an analysis of suzukis management
: Create an analysis of Suzuki's management decision to end its automobile sales in the US and a discussion of the hypothetical scenario presented below. Cite all of your sources and format your analysis according to APA style.
|
|
Construct cash flow statement computing incremental
: Robert montoya , inc case. Production of wine in unused section of the main plant. New machinery estimated cost 2,200,000 would be purchased, but shipping cost would be 18,000, an installation charges would add another 120,000 to the total equipment ..
|
|
Compare a filtering firewall to a proxy firewall
: Compare a filtering firewall to a proxy firewall in terms of protection against spoofing attacks,. Assume a configuration as in Figure 8.21, where the internal host under attack trusts the remote company user.
|