Question
Manal Pvt.Ltd. budgeted income statement for 1st quarter 2020 Description JANUARY FEBRUARY MARCH Sales 285,000 323,000 221,000 Purchases 129,000 168,000 95,000 Wages 35,000 37,000 30,000
Manal Pvt.Ltd. budgeted income statement for 1st quarter 2020 Description JANUARY FEBRUARY MARCH Sales 285,000 323,000 221,000 Purchases 129,000 168,000 95,000 Wages 35,000 37,000 30,000 Supplies 26,000 23,000 21,500 Utilities 6,500 8,700 7,200 Rent 15,000 12,800 13,600 Insurance 12,000 12,000 12,000 Advertising 24,500 28,500 18,000 Depreciation 20,000 20,000 20,000 Net Profit 17,000 13,000 3,700
Manal Receivable Trend: 30% of Sales are collected in the month of sale, 30% of Sales are collected after the month of sale. 40% of Sales are collected two months after the sale is made
Manal Payable Trend: 10% of Purchases are paid for in the month of purchase, 35% of Purchases are paid after the month of purchase, and 55% of Purchases are paid two months after the purchase is made
Additional Information:
Rent and Insurance expense were prepaid at the end of 2020 All other expenses are paid for in the month they were incurred
November Sales = 195,000 November Purchases = 100,000 December Sales = 250,000 December Purchases = 165,000
Please see attached Budgeted Income Statement for 1st Quarter 2020
Required: Calculate to show Jan-Mar 2020 cash collection from sale, cash payment of purchases and total expenses each month separately on the basis of above given data.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started