Managerial Accounting Assignment (Due: May 1, 2022 at 11:30 P.M. Managerial Accounting Assignment (Due: May 1, 2022 at 11:30 P.M. This is an excel assignment where we have to input the information...

Sheet1
    Ans 1    Expected Cash Collections :
        March Cash Collections     $5,100
        March Collections on account :

         January Sales    $3,750
         Februrary Sales     $19,500
         March Sales     $29,500
        Total Cash collections     $57,850
        Payment to Suppliers :
        Account payable for Inventory purchases, beginning balance    $10,500
        March Purchases     $14,100
        Total Cash Payment     $24,600
        Criteria for Collections on account :            January    February    March    Uncollectibles
        Month of Sales -Same Month-% of Collectibles     15%    Sales on Account     $25,000    $30,000    $40,000    $2,850
        Month following Sale -% of Collectibles     60%    Budgeted Inventory Purchases in March            23500
        Second Month following sale -% of Collectibles     22%
        Uncollectibles -% of Collectibles     3%    Pending
        Criteria for Inventiory Payments -
        Month of Purchase -% of Payables    60%
        Month following Purchase -% of Collectibles     40%
        S&P Enterprises
        Cash Budget
        For the Month of March
        Cash Balance ,March 1        $11,500    (Jan Cash receipt+Jan on account 1st Instalmnt.+January 2nd Instalmnt.) + (February Cash receipt+February on account 1st...