Question

In: Accounting

Ellis Corporation prepares its master budget on a quarterly basis. The following data have been assembled...

Ellis Corporation prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the third quarter of 2019:

  1. As of June 30, 2019 (the end of the prior quarter), the company's general ledger showed the following account balances:

                                                                                             Debits             Credits

      Cash                                                                             $25,000                                    Accounts Receivable          75,000

      Inventory                                                                       60,000

      Plant and Equip (net)                                                    190,000

      Accounts Payable                                                                                 $60,000

      Short-term Notes Payable                                                                       25,000

      Capital Stock                                                                                      190,000

      Retained earnings                                                         _______              75,000

                                                                                                                                                                        $350,000                                                                    $350,000

  1. Actual sales for June and budgeted sales for the next four months are as follows:

June 2019                                                                                           $160,000

July 2019                                                                                            220,000

August 2019                                                                                       320,000

September 2019                                                                                   140,000

October 2020                                                                                         80,000

  1. Monthly expenses are budgeted as follows: utilities, $12,000 per month; salaries and wages, $17,000 per month; rent, $25,000 per month; advertising, 4 percent of sales; depreciation, $10,000 per month; miscellaneous, 2 percent of sales
  2. At the end of each month, inventory is to be on hand equal to 30 percent of the following month's =
  3. Thirty-five percent of a month's inventory purchases are paid for in the month of purchase; the rest is paid for in the following month.
  4. Sales are 40 percent for cash and the rest are on account. All sales on account are collected the month following sale. The accounts receivable on June 30 are a result of June credit sales.
  5. The company's gross profit rate is 36 percent of sales.
  6. During July, the company will purchase a new computer for $16,000 in cash. During September, other equipment will be purchased for cash at a cost of $15,000. Assume there will be no equipment purchases in August 2019.
  7. During August and September, the company will declare and pay $15,000 and $13,000 in cash dividends, respectively. Assume no dividends will be paid in July.
  8. The company must maintain a minimum cash balance of $12,000. An open line of credit is available at a local bank for any borrowing that may be needed during the quarter. All borrowing is done at the beginning of a month, and all repayments are made at the end. Borrowings and repayments of principal must be in multiples of $1,000. Interest is paid at the end of each month. The interest rate is 12 percent per annum. (Figure interest in whole months, e.g., 1/12, 2/12.)

Solutions

Expert Solution


Related Solutions

Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter:
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: DebitsCreditsCash$48,000Accounts receivable224,000Inventory60,000Buildings and equipment (net)370,000Accounts payable$93,000Common stock500,000Retained earnings109,000$702,000$702,000 Actual sales for December and budgeted sales for the next four months are as follows: December(actual)$280,000January$400,000February$600,000March$300,000April$200,000 Sales are 20% for cash and 80% on credit. All...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Acct Receviable 48,000 Inventory 12,6000 Buildings & Equip. (net) 214,100 Acct. Payable 18,300 Common Stock 190,000 Retained Earnings 75,400 Totals 283,700 283,700 b. Sales for March total...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Acct Receviable 48,000 Inventory 12,6000 Buildings & Equip. (net) 214,100 Acct. Payable 18,300 Common Stock 190,000 Retained Earnings 75,400 Totals 283,700 283,700 b. Sales for March total...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Acct Receviable 48,000 Inventory 12,6000 Buildings & Equip. (net) 214,100 Acct. Payable 18,300 Common Stock 190,000 Retained Earnings 75,400 Totals 283,700 283,700 b. Sales for March total...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Accounts receivable        48,000 Inventory        12,600 Buildings and equipment (net)      214,100 Accounts payable          18,300 Common Stock        190,000 Retained earnings          75,400 Totals $283,700...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter. a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: Cash $9,000 Accounts receivable        48,000 Inventory        12,600 Buildings and equipment (net)      214,100 Accounts payable          18,300 Common Stock        190,000 Retained earnings          75,400 Totals $283,700...
Hancock Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Hancock Company, a merchandising company, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the second quarter. a. As of December 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances:   Cash $ 13,100   Accounts receivable 55,800   Inventory 18,620   Buildings and equipment (net) 135,000   Accounts payable $ 47,000   Common stock 115,000   Retained earnings 60,520 $ 222,520 $ 222,520 b. Actual...
Hancock Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...
Hancock Company, a merchandising company, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the second quarter a. As of December 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances:   Cash $ 13,100   Accounts receivable 55,800   Inventory 18,620   Buildings and equipment (net) 135,000   Accounts payable $ 47,000   Common stock 115,000   Retained earnings 60,520 $ 222,520 $ 222,520 b. Actual...
ABCCompany, an office supplies specialty store, prepares its master budget on a quarterly basis. The following...
ABCCompany, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the first quarter: a. As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: Debit Credit Cash $48,000 Accounts receivable 224,000 Inventory 60,000 Buildings and equipment (net) 370,000 Accounts payable $93,000 Capital shares 500,000 Retained earnings 109,000 $702,000 $702,000 b. Actual sales...
Edmonds Company, a sports specialty store, prepares its master budget on a quarterly basis. The following...
Edmonds Company, a sports specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: Edmonds Company Balance Sheet December 31, 2016 Cash $48,000 Accounts receivable $84,000 Inventory $80,000 Buildings and equipment (net) $490,000 $702,000 Accounts payable $90,000 Common stock $500,000 Retained earnings $112,000 $702,000 Information from marketing regarding sales: Actual Sales for December were $280,000. Sales Projections for January through April are: January:...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT