The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 401 Weeks Ago, 1 Day Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Welnor Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow:
| Ac€?c |
Sales are budgeted at $370,000 for November, $390,000 for December, and $380,000 for January. |
| Ac€?c |
Collections are expected to be 80% in the month of sale, 16% in the month following the sale, and 4% uncollectible. |
| Ac€?c | The cost of goods sold is 74% of sales. |
| Ac€?c |
The company desires ending merchandise inventory to equal 80% of the following month's cost of goods sold. Payment for merchandise is made in the month following the purchase. |
| Ac€?c | Other monthly expenses to be paid in cash are $21,500. |
| Ac€?c | Monthly depreciation is $16,500. |
| Ac€?c | Ignore taxes. |
Â
| Balance Sheet October 31 |
||
| Assets | ||
| Â Â Cash | $ | 22,500 |
| Â Â Accounts receivable (net of allowance for uncollectible accounts) | Â | 82,500 |
| Â Â Merchandise Inventory | Â | 219,040 |
| Â Â Property, plant and equipment (net of $663,000 accumulated depreciation) | Â | 1,170,000 |
| Â | Â | Â |
| Â Â Total assets | $ | 1,494,040 |
| Â | Â | Â |
| Liabilities and StockholdersAc€?c Equity | ||
| Â Â Accounts payable | $ | 199,500 |
| Â Â Common stock | Â | 890,000 |
| Â Â Retained earnings | Â | 404,540 |
| Â | Â | Â |
|   Total liabilities and stockholdersAc€?c equity | $ | 1,494,040 |
| Â | Â | Â |
| Â | ||
Â
|
Required: |
1.Prepare Cash Budgets for November and December. (Leave no cells blank - be certain to enter "0" wherever required. Input all amounts as positive values. Omit the "$" sign in your response.)
2.Prepare Budgeted Income Statements for November and December. (Input all amounts as positive values. Omit the "$" sign in your response.)
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll