Reference no: EM132273732
PROJECT
Minden Company is a wholesale distributor of premium European chocolates. It buys and sells the chocolate per box. The company's balance sheet as of April 30 is given below:
| Minden Company Balance Sheet March 31 (in Bhd) |
| Assets |
|
| Cash |
9,000 |
| Accounts receivable |
54,000 |
| Inventory |
0 |
| Buildings and equipment, net of depreciation |
207,000 |
| Total assets |
270,000 |
| Liabilities and Stockholders' Equity |
|
| Accounts payable |
63,000 |
| Note payable |
14,500 |
| Common stock |
180,000 |
| Retained earnings |
12,500 |
| Total liabilities and stockholders' equity |
270,000 |
The company is in the process of preparing a budget for April to June and has assembled the following data.
a. Based on historical data, selling price per box is Bhd110. The premium European chocolates cost per box is Bhd100 and monthly fixed expenses of Bhd5,000.00. Using the break-even in units, the management intends to sell 50% more from the break-even in units in the month of April and there will an 20% increase every month thereafter. The increase will be based on the previous month.
b. The collection pattern is as follows:
• 50% collected on the month of sale
• 30% collected on the following month of sales
• And the remaining will be on the second month of sale.
• All of the March 31 accounts receivable will be collected in April.
c. The desired ending inventory is 10% of the next month sales. These purchases will all be on account. Forty percent (40%) of all purchases are paid for in the month of purchase; the remainder are paid in the following month. All of the March 31 accounts payable to suppliers will be paid during April. There is no beginning inventory as of March 31.
d. Selling and administrative expenses is estimated to be 5% of the gross sales and these expenses will be paid in cash.
e. The note payable on the March 31 balance sheet will be paid during April, with Bhd100 in interest. (All of the interest relates to April.)
f. New refrigerating equipment costing Bhd6,500 will be purchased for cash during May.
g. The company will borrow in April 30,000 and in June, 20,000 from its bank by giving a new note payable to the bank for that amount. The new note will be due in one year.
h. Depreciation expense for the month is 1,000.
i. There is no dividend paid for the month
Required:
Part 1. Determine the break-even in boxes
Part II. Prepare the following schedules:
a) Schedule 1. Projected Sales Budget
b) Schedule 2. Collection Schedule
c) Schedule 3. Purchases Schedule of Premium European Chocolates in boxes and amount
d) Schedule 4. Payment Schedule for the Purchases of Premium European Chocolates
e) Schedule 5. Cash Budget Schedule
Part III. Determine the following:
a) Note 1. Accounts Receivable, end
b) Note 2. Inventory, end
c) Note 3. Buildings and Equipment, end
d) Note 4. Accounts Payable, end
e) Note 5. Notes Payable, end
Part IV. Prepare the following:
a. Budgeted Income Statement for the period ending June 30.
b. Projected Statement of Retained Earnings, end
c. Projected Balance Sheet as of June 30.
Additional Information:
Assuming that on June 30, the following financial informations were given to you for the analysis of the variances incurred.
|
Sales Information
|
|
|
Actual Number of Boxes Sold
|
2,700
|
|
Selling Price per box
|
100
|
For sales budgeted information, refer to Schedule 1. Projected Sales Budget.
|
Purchases Information
|
|
|
Actual Number of Boxes Sold
|
2,800
|
|
Selling Price per box
|
95
|
For purchases budgeted information, refer to Schedule 3. Purchases Schedule of Premium European Chocolates in boxes and amount
Part V. Determine the following variances and evaluate the variances
a. Quantity Sold Variance
b. Selling Price Variance
c. Sales Variance
e. Quantity Purchase Variance
f. Purchase Price Variance
g. Purchase Variance