a. | Simid Sports’ single product is purchased for $30 per unit andresold for $54 per unit. The expected inventory level of 5,250units on December 31, 2011, is more than management’s desired levelfor 2012, which is 20% of the next month’s expected sales (inunits). Expected sales are: January, 7,000 units; February, 8,750units; March, 10,500 units; and April, 9,500 units. |
b. | Cash sales and credit sales represent 25% and 75%, respectively,of total sales. Of the credit sales, 63% is collected in the firstmonth after the month of sale and 37% in the second month after themonth of sale. For the December 31, 2011, accounts receivablebalance, $125,000 is collected in January and the remaining$395,000 is collected in February. |
c. | Merchandise purchases are paid for as follows: 20% in the firstmonth after the month of purchase and 80% in the second month afterthe month of purchase. For the December 31, 2011, accounts payablebalance, $75,000 is paid in January and the remaining $300,000 ispaid in February. |
d. | Sales commissions equal to 20% of sales are paid each month.Sales salaries (excluding commissions) are $90,000 per year. |
e. | General and administrative salaries are $144,000 per year.Maintenance expense equals $2,000 per month and is paid incash. |
f. | Equipment reported in the December 31, 2011, statement offinancial position was purchased in January 2011. It is beingdepreciated over eight years under the straight-line method with noresidual value. The following amounts for new equipment purchasesare planned in the coming quarter: January, $34,000; February,$95,000; and March, $28,500. This equipment will be depreciatedunder the straight-line method over eight years with no residualvalue. A full month’s depreciation is taken for the month in whichequipment is purchased. |
g. | The company plans to acquire land at the end of March at a costof $145,000, which will be paid with cash on the last day of themonth. |
h. | Simid Sports has a working arrangement with its bank to obtainadditional loans as needed. The interest rate is 12% per year, andinterest is paid at each month-end based on the beginning balance.Partial or full payments on these loans can be made on the last dayof the month. The company has agreed to maintain a minimum endingcash balance of $32,740 in each month. |
i. | The income tax rate for the company is 37%. Income tax on thefirst quarter’s income will not be paid |
| Answer the following questions(5---8) |
5. | Monthly capital expenditures budgets. 6.Monthlycash budgets. |
| 7. | Budgeted income statement for the entire first quarter (not foreach month). |
|
8. | Budgeted statement of financial position as at March 31,2012. |