quik-flik company master budget project

Project Description:

quik-flik company
master budget project

you have just been hired as a new management trainee by quik-flik company, a nationwide distributor of a revolutionary new cigarette lighter. the company has an exclusive franchise on distribution of the lighter, and sales have grown so rapidly over the last few years that it has become necessary to add new members to the management team. you have been given direct responsibility for all planning and budgeting. your first task is to prepare a master budget for the next three months, starting april 1, 2006. you are anxious to make a favorable impression on the president and have assembled the information below.

sales data:
the lighters are forecast to sell for $8 each. recent forecast and/or actual sales in units are:

january (actual) 20,000
april - 35,000
july - 40,000

february (actual) 24,000
may - 45,000
august - 36,000

march (actual) 28,000
june - 60,000
september - 32,000

all sales are on credit (no cash sales). when preparing the sales budget, instead of showing the cash sales, credit sales and total sales, you will be creating a sales budget illustrating the budgeted units, the price per unit and then the total credit sales estimated. just a reminder, you are only doing three months and then the total for the quarter.

inventory, purchases and cost of goods sold:

the large buildup in sales before and during the month of june is due to father's day. the lighters cost the company $5 each. ending inventories are supposed to equal 90 percent of the next month's sales in units. remember, the desired ending inventory value is always expressed in terms of the cost ($5) of the lighters.

operating expenses:

the company's monthly operating expenses are given below:
sales commissions ............ $1 per lighter
wages and salaries............... 22,000
utilities.................................... 14,000
insurance expired................... 1,200
depreciation........................... 1,500
miscellaneous........................ 3,000

income statement:

for purposes of completing part 1 - the interest expense from the revised cash budget will be a given.

interest expense for the quarter is $3,018.

cash collections:

all sales are on credit, with no discount, and payable within 15 days. the company has found, however, that only 25% of a month's sales are collected by month-end. an additional 50% is collected in the month following, and the remaining 25% is collected in the second month following. bad debts have been negligible.

cash payments for purchases:

purchases are paid for as follows: 50% in the month of the purchase and the remaining 50% in the following month.

cash payments for operating expenses:

all operating expenses are paid during the month, in cash, with the exception of depreciation and insurance expired.

cash budget:

new fixed assets will be purchased during may for $25,000 cash. the company declares dividends of $12,000 each quarter, payable in the first month of the following quarter.

the company desires a minimum ending cash balance each month of $10,000.(if borrowing is required, borrow just enough to get to an ending cash balance of $10,000 and no more.) the company can borrow money from its bank at 12% annual interest. all borrowing must be done at the beginning of a month, and repayments must be made at the end of a month. repayments of principal must be in round $1,000 amounts. (principal and interest will not be in $1,000 amounts. remember when calculating interest on each borrowing to include the month it was borrowed plus the month(s) that balance was outstanding.) interest is computed and paid at the end of each quarter on all loans outstanding during the quarter. round all interest payments to the nearest whole dollar. compute interest on whole months (1/12, 2/12 and so forth). the company wishes to use any excess cash to pay loans off as rapidly as possible.

balance sheet:

the company's balance sheet at march 31 is given below:


$ 14,000

accounts receivable
$48,000 february sales; 25% of the total remains,
$168,000 march sales; 75% of the total remains

inventory (31,500 units)

unexpired insurance

fixed assets, net of depreciation

total assets
$ 574,600

liabilities and stockholders' equity:

accounts payable, (purchases)
$ 85,750

dividends payable

short-term notes payable

capital stock, no par

retained earnings

total liabilities and stockholders' equity
$ 574,600

income taxes are the responsibility of corporate headquarters, so you can ignore tax for budgeting purposes.

you are to complete a master budget for the quik-flik company for the second quarter april - june, 2006 in two parts.

part 1:
an example of the operating budget format i expect you to use can be found in the mid-chapter summary problem.

part 2:
an example of the financial budget format i expect you to use can be found in the end-of-chapter summary problem.

i expect all headings to be included for each schedule and good descriptions to precede the amounts in the columns. some of the given information will be a little different than the summary problem, however, you will need to make decisions on the best approach to handle that.
Skills Required:
Project Stats:

Price Type: Negotiable

Total Proposals: 0
1 Current viewersl
29 Total views
Project posted by:


Proposals Reputation Price offered

    There is no proposal yet.