Scribd Logo
Upload

Welcome to Scribd!

  • 20 views

    Ice Cream

    Uploaded by

    Nur Aida Mohd Sabri
    The document provides cost and sales data for various pineapple-flavored ice cream products sold in different portion sizes over four quarters. It details the product costs, markup prices, sales prices, sales volumes and resulting profits over time. The highest selling and most profitable products were the 250ml pineapple yogurt ice cream and 150ml pineapple mint ice cream. Overall, profits increased each quarter as sales volumes rose and costs remained steady.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Ice Cream

    Uploaded by

    Nur Aida Mohd Sabri
    20 views3 pages
    The document provides cost and sales data for various pineapple-flavored ice cream products sold in different portion sizes over four quarters. It details the product costs, markup prices, sales prices, sales volumes and resulting profits over time. The highest selling and most profitable products were the 250ml pineapple yogurt ice cream and 150ml pineapple mint ice cream. Overall, profits increased each quarter as sales volumes rose and costs remained steady.

    Original Title

    ICE CREAM.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides cost and sales data for various pineapple-flavored ice cream products sold in different portion sizes over four quarters. It details the product costs, markup prices, sales prices, sales volumes and resulting profits over time. The highest selling and most profitable products were the 250ml pineapple yogurt ice cream and 150ml pineapple mint ice cream. Overall, profits increased each quarter as sales volumes rose and costs remained steady.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    20 views3 pages

    Ice Cream

    Uploaded by

    Nur Aida Mohd Sabri
    The document provides cost and sales data for various pineapple-flavored ice cream products sold in different portion sizes over four quarters. It details the product costs, markup prices, sales prices, sales volumes and resulting profits over time. The highest selling and most profitable products were the 250ml pineapple yogurt ice cream and 150ml pineapple mint ice cream. Overall, profits increased each quarter as sales volumes rose and costs remained steady.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 3

    PRODUCT COST

    PRODUCT COST (RM) MISC (60%) MARK UP PRICE SALES PRICE

    Pineapple Yogurt Ice Cream 409.80 40.98 50% 430.29


    Pineapple with herbal tea 355.00 35.50 50% 372.75
    Pineapple with mint ice cream 360.00 36.00 50% 378.00
    Pineapple + chocolate chip 458.00 45.80 50% 480.90
    Pineapple + ginger 390.00 39.00 50% 409.50
    SALES ROUNDING 2071.44
    345.24
    SALES
    1ST QUARTER 2ND QUARTER 3RD QUARTER 4TH QUARTER
    JAN-MARCH APRIL-JUN JULY-SEP OCT-DEC
    3600 6000 8000 10000
    NO OF SALES (CUP)

    TOTAL FOOD COST (RM) RM1,242,864.00 RM2,071,440.00 RM2,761,920.00 RM3,452,400.00


    TOTAL FOOD SALES (RM) RM7,457,184.00 RM12,428,640.00 RM16,571,520.00 RM16,571,520.00
    OVERALL COST
    1ST QUARTER 2ND QUARTER 3RD QUARTER 4TH QUARTER
    JAN-MARCH APRIL-JUN JULY-SEP OCT-DEC
    FOOD COST RM 1,242,864.00 RM 2,071,440.00 RM 2,761,920.00 RM 3,452,400.00
    RENTAL RM 1,500.00 RM 1,500.00 RM 1,500.00 RM 1,500.00
    STAFF BUDGET RM 5,400.00 RM 5,400.00 RM 5,400.00 RM 5,400.00
    COST OF PACKAGING RM 504.00 RM 840.00 RM 1,120.00 RM 1,400.00
    COST OF UTILITIES RM 150.00 RM 150.00 RM 150.00 RM 150.00
    OVERALL COST RM 7,554.00 RM 7,890.00 RM 8,170.00 RM 8,450.00

    PROFIT AND LOSS


    GROSS PROFIT MARGIN RM 7,457,184.00 RM 12,428,640.00 RM 16,571,520.00 RM 16,571,520.00
    OVERALL COST RM 7,554.00 RM 7,890.00 RM 8,170.00 RM 8,450.00
    NET PROFIT RM 7,449,630.00 RM 12,420,750.00 RM 16,563,350.00 RM 16,563,070.00
    PROFIT/MONTH RM 2,483,210.00 RM 4,140,250.00 RM 5,521,116.67 RM 5,521,023.33
    90 ml
    PRODUCT
    No of Sales (ML) Cost (RM) Sales Price (RM)
    Pineapple Yogurt Ice Cream 252000 0.66 2.97
    Pineapple Ice Cream Caramel 207000 0.53 2.39
    Pineapple With Herbal Tea 117000 0.35 1.58
    Pineapple Mint Ice Cream 288000 0.38 1.71
    Pineapple + Ginger 108000 0.25 1.13

    150 ml
    PRODUCT
    No of Sales (ML) Cost (RM) Sales Price (RM)
    Pineapple Yogurt Ice Cream 420000 1.10 4.95
    Pineapple Ice Cream Caramel 345000 0.71 3.20
    Pineapple With Herbal Tea 195000 0.58 2.61
    Pineapple Mint Ice Cream 480000 0.63 2.84
    Pineapple + Ginger 180000 0.42 1.89

    250 ml
    PRODUCT
    No of Sales (ML) Cost (RM) Sales Price (RM)
    Pineapple Yogurt Ice Cream 700000 1.83 8.24
    Pineapple Ice Cream Caramel 575000 1.47 6.62
    Pineapple With Herbal Tea 325000 0.97 4.37
    Pineapple Mint Ice Cream 800000 1.06 4.77
    Pineapple + Ginger 300000 0.69 3.11
    Total Sales (RM)
    RM 748,440.00
    RM 493,695.00
    RM 184,275.00
    RM 492,480.00
    RM 121,500.00

    Total Sales (RM)


    RM 2,079,000.00
    RM 1,102,275.00
    RM 508,950.00
    RM 1,360,800.00
    RM 340,200.00

    Total Sales (RM)


    RM 5,764,500.00
    RM 3,803,625.00
    RM 1,418,625.00
    RM 3,816,000.00
    RM 931,500.00

    You might also like