In: Accounting
Managerial Accounting Case 2
McMurray & Sons is a retailer of stuffed animals. All items in the store sell for the same $18 selling price. McMurray estimates that 25% of its sales are for cash and 75% are on account.
Other information regarding the company's budgeted sales and collection of credit sales are as follows:
Budgeted sales in units Credit Sales Collection Pattern December 9,000 Collected in same month as sale 50% January 1,000 Collected 1 months following sale 50% February 2,000 March 2,500 April 3,000 McMurray buys its animals from one supplier at a cost of $6 per animal. It pays for all of its merchandise purchases in the month following purchase. McMurray began January with 100 stuffed animals in inventory. The company has an purchases budget policy of having 10% of the following month's anticipated sales in stock at the end of every month. December's purchases totaled $49,200. McMurray's monthly expenses are as follows: $ 1,500 Depreciation of store building & fixtures 10,000 Salaries and other payroll items 2,500 Advertising 2,000 Utilities 7,000 Other operating expenses $ 23,000 In addition to these expenses, McMurray pays insurance premiums of $4,000 in January and June, and pays $5000 in property taxes every February. McMurray began January with $25,000 in its bank account. The company maintains a minimum cash balance of $25,000. An open line of credit is available from the company's bank to bolster its cash position when needed. Any excess cash over $25,000 should be applied against monies borrowed. (Ignore interest)
REQUIRED:
(1) Prepare a schedule of cash collections for January, February, and March.
(2) Prepare a merchandise purchases budget for January, February, and March.
(3) Prepare a cash budget for January, February, and March.