Sturgeon Industries Q Budget,
The following information has been assembled to assist in preparing a master budget for Sturgeon
Industries for the third quarter of July through September.
At June the company's general ledger account balances were:
a Actual sales for June and budgeted sales for the next four months are as follows:
b of sales are for cash. All payments on credit sales are collected in the month following the sale.
c The gross margin is of sales.
d Each month's ending inventory should equal of the following month's budgeted cost of goods sold.
e Onequarter of each month's inventory purchases is paid for in the month of purchase; the balance
due is paid for in the following month.
f Monthly cash expenses include commissions, $; rent, $; other expenses excluding
depreciation of sales.
g Depreciation is calculated quarterly, in the last month of each quarter. For Q total
depreciation is $ This amount includes depreciation on new assets acquired during the quarter.
h Equipment will be purchased for cash in July for $ and in August for $
i Management would like to maintain a minimum cash balance of $ at the end of each month.
The company has an agreement with a local bank that allows it to borrow up to a total loan balance
of $ Borrowings and repayments of principal must be in multiples of $ When required,
borrowing occurs at the beginning of the month and repayment is done at the end of the month.
Interest is paid only at the time of payment of principal. The annual interest rate is It is not
compounded. Calculate interest on whole months, for example
Required: Use the budget example on pages through as an example
Complete a full set of budgets, including schedule of expected cash collections, inventory purchase
budget, schedule of expected cash payments for inventory purchases, schedule of cash payments
for operating expenses, cash budget.
Prepare a projected income statement for the third quarter of and prepare a projected
balance sheet for the end of the third quarter.
It is done on excel
