Please give positive ratings so I can keep answering. Thanks! |
Timpco | |||||
Budgeted Sales | October | November | December | Note | |
Cash sale | 120,000.00 | 99,000.00 | 97,000.00 | A | |
Credit sale | 120,000.00 | 118,800.00 | 106,700.00 | B | |
Budgeted Sales | 240,000.00 | 217,800.00 | 203,700.00 | C=A+B | |
Budgeted Cash Receipts | October | November | December | ||
Credit sale | 120,000.00 | 118,800.00 | 106,700.00 | See B | |
95% of Credit sale are collectible | 114,000.00 | 112,860.00 | 101,365.00 | D=B*95% | |
60% of collectible credit sale in the same month | 68,400.00 | 67,716.00 | 60,819.00 | E= 60% of D | |
40% of collectible credit sale in the next month | - | 45,600.00 | 45,144.00 | F= 40% of D of previous month | |
Cash sale | 120,000.00 | 99,000.00 | 97,000.00 | See A | |
Total Cash Receipts before discount | 188,400.00 | 212,316.00 | 202,963.00 | G=E+F+A | |
75% of collectible credit sale | 85,500.00 | 84,645.00 | 76,023.75 | H=D*75% | |
Cash discount of 1.5% on 75% of collectible credit sale | 1,282.50 | 1,269.68 | 1,140.36 | I=H*1.5% | |
Total Cash Receipts after discount | 187,117.50 | 211,046.33 | 201,822.64 | J=G-I | |
So budgeted total Cash Receipts | 187,117.50 | 211,046.33 | 201,822.64 | See J | |
Cost of goods sold Budget | October | November | December | January | |
Budgeted Sales | 240,000.00 | 217,800.00 | 203,700.00 | 193,000.00 | See C |
Less: Gross profit @ 30% | 72,000.00 | 65,340.00 | 61,110.00 | 57,900.00 | K= C*30% |
Cost of goods sold Budget | 168,000.00 | 152,460.00 | 142,590.00 | 135,100.00 | L=C-K |
Material Purchase Budget | October | November | December | January | |
Cost of goods sold Budget | 168,000.00 | 152,460.00 | 142,590.00 | 135,100.00 | See L |
Material to be Purchased | 152,460.00 | 142,590.00 | 135,100.00 | M= 100% of L of next month | |
Budgeted cash disbursements | October | November | December | January | |
Material Purchase Budget | 152,460.00 | 142,590.00 | 135,100.00 | See M | |
20% paid in the same month | 30,492.00 | 28,518.00 | 27,020.00 | N= M*20% | |
80% paid in the next month | 121,968.00 | 114,072.00 | O= 80% of M of previous month | ||
Budgeted cash disbursements | 150,486.00 | 141,092.00 | P= N+O | ||
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding...
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $ 125,000 $ 103,000 $ 99,000 Credit sales 125,000 123,600 108,900 Total $ 250,000 $ 226,600 $ 207,900 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are...
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November $ 95,000 114,000 209,000 December $ 95,000 104,500 Cash sales 115,000 115,000 230,000 Credit sales 199,500 Total Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month...
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: November $59,000 October December $ 65,000 65,000 $130,000 $77,000 Cash sales Credit sales 70,800 $ 129,800 84,700 $161,700 Total Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month...
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $ 115,000 $ 95,000 $ 95,000 Credit sales 115,000 114,000 104,500 Total $ 230,000 $ 209,000 $ 199,500 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are...
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $ 155,000 $ 127,000 $ 111,000 Credit sales 155,000 152,400 122,100 Total $ 310,000 $ 279,400 $ 233,100 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are...
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $ 150,000 $ 123,000 $ 109,000 Credit sales 150,000 147,600 119,900 Total $ 300,000 $ 270,600 $ 228,900 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are...
Timpco, a retailer, makes both cash and credit sales (ie, sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: Cash sales Credit sales Total October $ 100,00 160,000 5 200.000 November $ 120.000 150,000 $ 270, eee December $ 80,000 90,000 $ 170,000 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40%...
Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales $ 140,000 $ 115,000 $ 105,000 Credit sales 140,000 138,000 115,500 Total $ 280,000 $ 253,000 $ 220,500 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are...
Timpco, a retailer, makes both cash and credit sales (.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: Cash sales Credit sales Total October $ 115,000 115,800 $ 230,000 November $ 95,000 114,000 $ 209,000 December $ 95,000 104,500 $ 199,500 Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are...
please solve all the queations, thanks. [LO 10-4) 10-26 Budgeted Cash Receipts and Cash Disbursements Timpco, a retailer, makes both cash and credit sales (.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows: October November December Cash sales Credit sales $100,000 100,000 $200,000 $ 120.000 150,000 $ 270,000 $ 80,000 90,000 $ 170,000 Total Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are...