Here is a summary of the transaction for the business during the year (all amounts in KES) as well as key terms: I. Injected into the business share capital of 500,000 on commencement of operations 2. The business is to buy hand carts at 5,000 each, charge a 20% mark-up then resell 3. Millis pays for the hand carts up front 4. At the beginning of every month (including the first month of operations), Millie buys 50 hand carts and keeps them as inventory 5. Customers pay for the hand cans upfront when buying 6. Millie sold a total of 562 hand carts in the year. The monthly sales are as follows: Hand carts sold in January: 10 Hand carts sold in February: 45 c Hand carts sold in March: 46 Hand carts sold in April: 46 Hand carts sold in May: 47 Hand carts sold in June: 48 Hand carts sold in July: 49 I land carts sold in August 50 Hand carts sold in September 52 Hand carts sold in October: 54 Hand carts sold in November: 56 7. Millie will deduct monthly rent for this business of 7,500 at the beginning of every month, with a rent of 5,000 for January 8. Millie will pay herself a salary of 25,000 per month at the end of the month 9. The business incurs other operating expenses of 10,000 per month, paid by each immediately 10. No tax charge is recognized in the management accounts - this will be computed later once year end accounts have been prepared Your tasks: • Prepare monthly income statement

Respuesta :

The preparation of the monthly income statement for Millie Company for the year is as follows.

Monthly Income Statement:

             Jan.  Feb.  Mar.  Apr.  May  Jun.  Jul.  Aug.  Sep.   Oct.  Nov.   Dec.

Sales Revenue (in thousands)

Sales

Units     10     45     46     46     47    48    49    50      52      54     56      59

Sales $60 $270 $276 $276 $282 $288 $294 $300 $312 $324 $336 $354

Cost of goods

sold $50 $225 $230 $230 $235 $240 $245 $250 $260 $270 $280 $295

Gross

Profit $10  $45   $46    $46  $47    $48    $49   $50    $52  $54  $56    $59

Rent      5    7.5    7.5      7.5   7.5     7.5      7.5     7.5      7.5   7.5    7.5      7.5

Operating

 Exp.   10    10    10        10    10       10       10      10        10     10     10          10

Total

exp. $15 $17.5 $17.5 $17.5 $17.5 $17.5  $17.5 $17.5  $17.5 $17.5 $17.5  $17.5

Net Income

      ($5) $27.5 $28.5 $28.5 $29.5 $30.5 $31.5 $32.5 $34.5 $36.5 $38.5

$41.5

What is the monthly income statement?

The monthly income statement is a summary of the business revenue and operating expenses for every month during the fiscal year.

For Millie, the income statement records the sales revenue (Sales price multiplied by Sales units) minus the cost of goods sold (Cost price multiplied by the cost per unit) to determine the gross profit.

From the gross profit, the monthly rent and operating expenses are deducted, to determine the net income (profit or loss).

Data and Calculations:

Cost of goods sold per cart = $5,000

Markup = 20%

Sales price per cart = $6,000 ($5,000 x 1.2)

Learn more about income statements at https://brainly.com/question/21851842

#SPJ1