Merchandising Company Budgeted Income Statement and Cash Budget (LO2, LO3).

Bargain Mart is formulating its budget for the third quarter of the coming year. Rev- enue estimates are $800,000 for July, $1,200,000 for August, and $1,000,000 for Septem- ber. While markups on individual items vary, management estimates that the average selling price exceeds the average purchase cost by 25% (e.g., Bargain Mart expects to generate revenue of $125 on an item purchased for $100). In terms of inventory, Bar- gain Mart targets to have merchandise on hand equal to 30% of the following months cost of goods sold. In addition to the cost of goods purchased, Bargain Mart budgets 60 hours of labor, at a cost of $12.50 per hour, for every $16,000 of revenue. Bargain Marts supervisory staff costs $28,000 per month, and rent and utilities amount to $35,000 per month. Other expenses equal 5% of the current months revenue, with $10,000 of this total representing non-cash depreciation on storage racks.

Assume Bargain Mart collects 80% of its revenue in the month of sale and the remain- der in the following month. Bargain Mart pays for 60% of its purchases in the month of purchase and the remainder in the following month. Bargain Mart also expects to buy and pay for some new display units, costing $40,000, in August. Finally, Bargain Mart expects to begin August with a cash balance of $85,000. Required: a. What is Bargain Marts purchases budget for August?

b. What is Bargain Marts direct labor budget for August? c. What is Bargain Marts budgeted income statement for August? d. What is Bargain Marts cash budget for August?