REQUIRED:

Purchase budget and cash disbursement for purchase

Budget Data LMN Co. Assets as at March 31, 2011 Liabilities and Equity as at March 31, 2011 Accounts Payable Lease Payable 3000 11000 Cash Accounts Receivable Inventory(note 1) Prepaid Supplies Equipment 4000 9000 10000 900 21000 Owners Equity 30900 Total Assets 44900 Total Liabilities and Equity 44900 Required: Prepare a Quarterly Master budget for LMN Co. For the months of April, May and June, Up to and Including the Income Statement Notes: Inventory as at March 31, 2011 consists of 2,000 calculators at a cost of $5.00 per calculator. 2) LMN Co. sells boxes at a selling price per calculator is: $ 8.00 Expected Sales in units: April May June July August 5,000 6,000 8,000 2,000 7,000 4) All sales are on credit and are collected as follows: Month of Sale Month after Sale There are no bad debts 65% 35% 5 $ 5.00 The Wholesale cost per calculator is: Payments for wholesale purchases are: Month of Purchase Month after Purchase 80% 20% Desired Ending Inventory is 10% of next months sales Operating expenses monthly are: Wages $ 9,500.00 Freight 1% of sales Rent $ 2,500.00 Depreciation $ 900.00 Miscellaneaous $ 600.00 Office Equipment is purchased in April for: $ 7,000 Monthly minimum cash balance required $ 4,000.00 Monthly interest on borrowed funds: 1% Assume funds are borrowed at the beginning of the month that they are needed and repaid at the end of the month where excess cash permits repayment Assume simple interest rate, no compounding Interest is repaid at the time of the loan repayment. April May June Total Purchases Budget Sales Units Desired Ending Inventory Beginning Inventory Required Purchases in units Cost per box Cost of box Purchases Cash Disbursements for Purchases April April May May June June Total Total Payment for Current Month Purchases Payment for Prior Month Purchases Total Cash Disbursements for Purchases