Q1) Master Budget with Supporting Schedules
Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces, has an exclusive franchise on the distribution of the necklaces, and sales have grown so rapidly over the past few years that it has become necessary to add new members to the management team. To date, the company’s budgeting practices have been inferior, and, at times, the company has experienced a cash shortage. You have been given responsibility for all planning and budgeting. Your first assignment is to prepare a master budget for the next three months, starting April 1.
You are anxious to make a favourable impression on the president and have assembled the information below.
The necklaces are sold to retailers for $10 each. Recent and forecasted sales in units are as follows:
22,000 June 54,000
30,000 July 34,000
March (actual) 43,000 August 32,000
April 69,000 September 29,000
The large buildup in sales before and during May is due to Mother’s Day. Ending
inventories should be equal to 40% of the next month’s sales in units.
The necklaces cost the company $4 each. Purchases are paid for as follows: 50% in the month of purchase and the remaining 50% in the following month. All sales are on credit, with no discount, and payable within 15 days. The company has found, however, that only 20% of a month’s sales are collected by month-end. An additional 70% is collected in the following month, and the remaining 10% is collected in the second month following sale. Bad debts have been negligible.
The company’s monthly selling and administrative expenses are given below:
Sales commissions 4 % of sales
Advertising $ 212,000
Wages and salaries 110,800
All selling and administrative expenses are paid during the month, in cash, with the exception of depreciation and insurance. Insurance is paid on an annual basis, in November of each year. The company plans to purchase $17,600 in new equipment during May and $44,000 in new equipment during June; both purchases will be paid in cash. The company declares dividends of $15,800 each quarter, payable in the first month of the following quarter. The company’s balance sheet at March 31 is given below:
Cash $ 78,000
Accounts receivable ($30,000 February sales;
$344,000 March sales)
Prepaid insurance 26,600
Fixed assets, net of depreciation 970,000
Total assets $ 1,559,000
Liabilities and Shareholders’ Equity
Accounts payable $ 106,800
Dividends payable 15,800
Common shares 840,000
Retained earnings 596,400
Total liabilities and shareholders’ equity $ 1,559,000
The company wants a minimum ending cash balance each month of $50,000. All borrowing is done at the
beginning of the month, with any repayments made at the end of the month. The interest rate on these loans is 1%
per month and must be paid at the end of each month based on the outstanding loan balance for that month.
Prepare a master budget for the three-month period ending June 30. Include the following detailed budgets:
a. A sales budget by month and in total.
b. A schedule of expected cash collections from sales, by month and in total.
A merchandise purchases budget in units and in dollars. Show the budget by month and in total.
A schedule of expected cash disbursements for merchandise purchases, by month and in total.
2. A budgeted income statement for the three-month period ending June 30. Use the variable costing approach.
Q2) FLEXIBLE BUDGET
(Indicate each variance as “F” for favourable or “U” for unfavourable).
Q3) Material and Labour Variances
The direct materials and direct labour standards for one bottle of Clean-All spray cleaner are given below:
Direct materials 5.0 millilitres $ 0.30
Direct labour 0.4 hours $12.00 per hour $4.80
During the most recent month, the following activity was recorded:
a. 28,000 millilitres of material was purchased at a cost of $0.25 per millilitre.
b. All of the material was used to produce 3,000 bottles of Clean-All.
c. 675 hours of direct labour time was recorded at a total labour cost of $8,100.
1. Compute the direct materials price and quantity variances for the month.
2. Compute the direct labour rate and efficiency variances for the month.
(Indicate each variance as “F” for favourable or “U” for unfavourable).
Why Choose Us
We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.
Professional Academic Writers
Over the years, our Acme Homework has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keep up with the rising Academic Trends.
Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.
We pay strict attention on deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.
At Essay Writing Help, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.
Customer Support 24/7
Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email: email@example.com.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Essay Writing Help has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.
At Essay Writing Help, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.
Admission and Business Papers
Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.
Editing and Proofreading
Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.
We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.