Unici Company is a retail company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, 2006. The company president formed a planning committee to prepare a master budget for the first three months of operation. He assigned you, the budget coordinator, the following tasks.
Budgeted selling and administrative expenses per month follow.
Salary expense (fixed) $18,000
Sales commissions 5 percent of Sales
Supplies expense 2 percent of Sales
Utilities (fixed) $1,400
Depreciation on store equipment (fixed)* $4,000
Rent (fixed) $4,800
Miscellaneous (fixed) $1,200
*The capital expenditures budget indicates that Unici will spend
$164,000 on October 1 for store fixtures, which are expected to have a
$20,000 salvage value and a three-year (36-month) useful life.
Use this information to prepare a selling and administrative expenses budget.
f. Utilities and sales commissions are paid the month after they are incurred; all other expenses are paid in the month in which they are incurred. Prepare a cash payments budget for selling and administrative expenses.
g. Unici borrows funds, in increments of $1,000, and repays them on the last day of the month. The company also pays its vendors on the last day of the month. It pays interest of 1 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $12,000 cash cushion. Prepare a cash budget.
h. Prepare a pro forma income statement for the quarter.
i. Prepare a pro forma balance sheet at the end of the quarter.
j. Prepare a pro forma statement of cash flows for the quarter.