On January 1, Easton Company had cash on hand of $115,000. All of January's $244,000 sales...
On January 1, Easton Company had cash on hand of $115,000. All of January's $244,000 sales were on account. December sales of $230,000 were also all on account. Experience has shown that Easton typically collects 30% of receivables in the month of the sale and the balance the following month. All materials and supplies are purchased on account and Easton has a history of paying for half of these purchases in the month of purchase and half the following month. Such purchases were $156,000 for December and $157,000 for January. All other expenses including wages are paid in the month incurred. These amounted to $42,000 in December and $64,000 in January. Use this information to determine the projected ending balance of cash on hand for January. (Round answer to the nearest whole dollar)
Homework Answers
Cash budget for January
| Beginning cash balance | 115,000 |
| Cash receipts from customers: | |
| - December sales (230,000 x 70%) | 161,000 |
| - January sales (244,000 x 30%) | 73,200 |
| Total available cash | 349,200 |
| Cash payments: | |
| Cash payment to suppliers | |
| - December purchases (156,000 x 1/2) | - 78,000 |
| - January purchases (157,000 x 1/2) | - 78,500 |
| Other expenses | - 64,000 |
| Ending cash balance | 128,700 |
Projected ending balance of cash on hand for January = $128,700
Kindly comment if you need further assistance. Thanks
Add Answer to:
On January 1, Easton Company had cash on hand of $115,000. All
of January's $244,000 sales...
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 $ 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...
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...
Information pertaining to Noskey Corporation's sales revenue follows: Cash sales Credit sales Total sales November 2018...
Information pertaining to Noskey Corporation's sales revenue follows: Cash sales Credit sales Total sales November 2018 (Actual) $ 105,000 270,000 $ 375,000 December 2018 (Budgeted) $ 115,000 395,000 $ 510,000 January 2019 (Budgeted) $ 70,000 200,000 $ 270,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next...
Sales are made on a cash basis only. Koehl's purchases must be paid for during the...
Sales are made on a cash basis only. Koehl's purchases must be paid for during the following month. Koehl pays herself a salary of $4,600 per month, and the rent is $2,100 per month. In addition, she must make a tax payment of $12,000 in December. The current cash on hand (on December 1) is $850, but Koehl has agreed to maintain an average bank balance of $4,500 - this is her target cash balance. (Disregard the amount in the...
Timpco, a retailer, makes both cash and credit sales (.e., sales on open account). Information regarding budgeted sales...
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...
Sales are 65% cash and 35% credit. Credit sales are collected 10% in the month of...
Sales are 65% cash and 35% credit. Credit sales are collected 10% in the month of sale and the remainder in the month after sale. Actual sales in December were а. $57,000. Schedules of budgeted sales for the two months of the upcoming year are as follows: Budgeted Sales Revenue $58,000 January February $72,000 Actual purchases of direct materials in December were $25,000. The company's purchases of direct materials in January are budgeted to be $22,500 and $27,000 in February....
Company has $ 13500 in cash on hand on January 1 and has collected the following...
Company has $ 13500 in cash on hand on January 1 and has
collected the following budget data: Assume Hess has cash payments
for selling and administrative expenses including salaries of $
55000 plus commissions of 2% of sales, all paid in the month of
sale. The company requires a minimum cash balance of $ 11000.
Prepare a cash budget for January and February. Will Hess need to
borrow cash by the end of February? Begin by preparing the cash...
A firm has actual sales in November of $1,000 and projected sales in December and January...
A firm has actual sales in November of $1,000 and projected sales in December and January of $3,000 and $4,000, respectively. The firm makes 10 percent of its sales for cash, collects 40 percent of its sales one month following the sale, and collects the balance two months following the sale. The firm's total cash receipts in January is 4 $3,300 $2,100 $2,000 $400
Yosko has $14,500 in cash on hand on January 1 and has collected the following budget...
Yosko has $14,500 in cash on hand on January 1 and has collected the following budget data: (Click on the icon to view the budget data.) Assume direct labor costs and manufacturing overhead costs are paid in the month incurred. Additionally, assume Yosko has cash payments for selling and administrative expenses including salaries of $55,000 per month plus commissions that are 2% of sales, all paid in the month of sale. The company requires a minimum cash balance of $15,000....
Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $...
Information pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $ 113,000 $ 142,000 $ 95,000 Credit sales 305,000 467,000 251,000 Total sales $ 418,000 $ 609,000 $ 346,000 Management estimates that 5% of credit sales are eventually uncollectible. Of the collectible credit sales, 60% are likely to be collected in the month of sale and the remainder in the month following the month of sale. The company desires to begin each month with an...
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...
Information pertaining to Noskey Corporation's sales revenue follows: Cash sales Credit sales Total sales November 2018 (Actual) $ 105,000 270,000 $ 375,000 December 2018 (Budgeted) $ 115,000 395,000 $ 510,000 January 2019 (Budgeted) $ 70,000 200,000 $ 270,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next...
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...
Sales are 65% cash and 35% credit. Credit sales are collected 10% in the month of sale and the remainder in the month after sale. Actual sales in December were а. $57,000. Schedules of budgeted sales for the two months of the upcoming year are as follows: Budgeted Sales Revenue $58,000 January February $72,000 Actual purchases of direct materials in December were $25,000. The company's purchases of direct materials in January are budgeted to be $22,500 and $27,000 in February....
Company has $ 13500 in cash on hand on January 1 and has
collected the following budget data: Assume Hess has cash payments
for selling and administrative expenses including salaries of $
55000 plus commissions of 2% of sales, all paid in the month of
sale. The company requires a minimum cash balance of $ 11000.
Prepare a cash budget for January and February. Will Hess need to
borrow cash by the end of February? Begin by preparing the cash...
A firm has actual sales in November of $1,000 and projected sales in December and January of $3,000 and $4,000, respectively. The firm makes 10 percent of its sales for cash, collects 40 percent of its sales one month following the sale, and collects the balance two months following the sale. The firm's total cash receipts in January is 4 $3,300 $2,100 $2,000 $400
Yosko has $14,500 in cash on hand on January 1 and has collected the following budget data: (Click on the icon to view the budget data.) Assume direct labor costs and manufacturing overhead costs are paid in the month incurred. Additionally, assume Yosko has cash payments for selling and administrative expenses including salaries of $55,000 per month plus commissions that are 2% of sales, all paid in the month of sale. The company requires a minimum cash balance of $15,000....
Most questions answered within 3 hours.
-
What taboo subject did Ida B. Wells suggest was consensual
between black men and white women?...
asked 1 hour ago -
You have just been hired by the EPA to help with the new gas
mileage standards...
asked 2 hours ago -
4) A firm is hit by increases in its wage rate, w.
a) How does this...
asked 2 hours ago -
A square current loop 5.4 cm on each side carries a 510 mA
current. The loop...
asked 4 hours ago -
What are five tips in conducting knowledge assessment/literature
review research? Each of these tips needs to...
asked 5 hours ago -
Antigen presenting cells link innate and adaptive immune
responses. In the theoretical scenario where phagosomes cannot...
asked 5 hours ago -
Dealing with conflict, in my opinion, is a skill and an art. I
believe that those...
asked 6 hours ago -
6. A long straight wire with circular cross section and radius
1.5 cm carries a 1.2...
asked 6 hours ago -
Deacon Corporation has provided the following financial data
from its balance sheet and income statement:
Year...
asked 6 hours ago -
List and discuss at least three variables from everyday life for
which you expect the variable ...
asked 6 hours ago -
A high-pass filter consists of a 1.60 μF capacitor in series
with a 125 Ω resistor....
asked 6 hours ago -
A newly developed artificial intelligence has trouble
distinguishing hand-written numbers from hand-written alphabets.
There are pictures...
asked 7 hours ago