Can you show me how to get each answer/the calculations?
Answer 5
c. $ 431,600
Calculations:
Formulae used
Answer 6
e. None of the above
Calculations:
Opening cash | $ 20,000 |
Add: Collections from sale | $ 492,000 |
Less: Purchases | |
March (400000*0.70*0.25) | $ 70,000 |
Feb (550000*0.70*0.75) | $ 288,750 |
Less: Operating expenses | $ 120,000 |
Closing cash | $ 33,250 |
In case of any doubt, please comment.
Can you show me how to get each answer/the calculations? The following data apply to questions...
Can you do this in excel and show what functions you use to get
the quarter totals and other totals. Can you also do the sales
budget
I need to create an entire master budget.
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods Current assets as of March 31: Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings $ 8,500 $ 24,000 $ 45, 600 $ 121,200...
Can anyone help me with the ones that are wrong?
Also explain how you get the answers
nment 6 Help Save 8 c Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales d. Each month's ending inventory should equal 80% of the following month's budgeted cost of goods sold. e. One-half of a month's inventory purchases is paid...
can you please answer this and show me how you arrived
at the answer. thanks
Check my work You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting,...
Can you please show me what the sales budget for this
information would be in excel. Thank you
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash Accounts receivable Inventory Building and equipment, net Accounts payable Common stock Retained earnings $ 8,500 $ 24,000 $ 45, 600 $ 121,200 $ 27,300 $ 150,000 $ 22,000 a. The gross margin is 25% of sales. b. Actual and...
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...
nformation pertaining to Yekstop Corp.'s sales revenue is presented below: November December January Cash sales $ 101,000 $ 130,000 $ 83,000 Credit sales 293,000 455,000 239,000 Total sales $ 394,000 $ 585,000 $ 322,000 Management estimates that 4% of credit sales are eventually uncollectible. Of the collectible credit sales, 65% 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 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...
Hello, these are 3 questions I need help with, if you
can show me how to get the answer as well. thank you for your
time.
2 Green Thumb Gardening is a small gardening service that uses activity-based costing to estimate costs for pricing and other purposes. The proprietor of the company believes that costs are driven primarily by the size of customer lawns, the size of customer garden beds, the distance to travel to customers, and the...
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...
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 9,300 Accounts receivable $ 27,200 Inventory $ 50,400 Building and equipment, net $ 102,000 Accounts payable $ 30,300 Common stock $ 150,000 Retained earnings $ 8,600 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 68,000 April $ 84,000 May $ 89,000 June $ 114,000 July $ 65,000 Sales are...