ACCT207 Lecture Notes - Lecture 2: Perpetual Inventory, Gross Profit, Cash Register
Document Summary
Get access
Related Documents
Related Questions
Welnor Industrial Gas Corporation supplies acetylene and othercompressed gases to industry. Data regarding the store's operationsfollow: |
⢠| Sales are budgeted at $330,000 for November, $350,000 forDecember, and $340,000 for January. |
⢠| Collections are expected to be 70% in the month of sale, 26% inthe month following the sale, and 4% uncollectible. |
⢠| The cost of goods sold is 67% ofsales. |
⢠| The company desires ending merchandise inventory to equal 85% ofthe following month's cost of goods sold. Payment for merchandiseis made in the month following the purchase. |
⢠| Other monthly expenses to bepaid in cash are $21,900. |
⢠| Monthly depreciation is$16,900. |
⢠| Ignore taxes. |
Balance Sheet October 31 | ||
Assets | ||
Cash | $ | 22,900 |
Accounts receivable(net of allowance for uncollectible accounts) | 82,900 | |
MerchandiseInventory | 187,935 | |
Property, plant andequipment (net of $667,000 accumulated depreciation) | 1,170,000 | |
Total assets | $ | 1,463,735 |
Liabilities and Stockholdersâ Equity | ||
Accountspayable | $ | 199,900 |
Common stock | 930,000 | |
Retainedearnings | 333,835 | |
Total liabilitiesand stockholdersâ equity | $ | 1,463,735 |
Required: |
a. | Prepare a Schedule of Expected Cash Collections for November andDecember. (Omit the "$" sign in yourresponse.) |
Welnor Industrial Gas Corporation Schedule of Expected Cash Collections | |||
November | December | ||
Sales | $ | $ | |
Schedule of ExpectedCash Collections | |||
Accountsreceivable | $ | ||
November sales | $ | ||
December sales | |||
Total cashcollections | $ | $ | |
b. | Prepare a Merchandise Purchases Budget for November andDecember. (Input all amounts as positive values. Do notround intermediate calculations. Omit the "$" sign in yourresponse.) |
Welnor Industrial Gas Corporation Merchandise Purchases Budget | |||
November | December | ||
Budgeted cost ofgoods sold | $ | $ | |
(Click toselect)AddDeduct: (Click to select)Beginning merchandiseinventoryDesired ending merchandising inventory | |||
Total needs | |||
(Click toselect)DeductAdd: (Click to select)Beginning merchandiseinventoryDesired ending merchandising inventory | |||
Requiredpurchase | $ | $ | |
c. | Prepare Cash Budgets for November and December. (Leaveno cells blank - be certain to enter "0" wherever required. Inputall amounts as positive values. Omit the "$" sign in yourresponse.) |
Welnor Industrial Gas Corporation Cash Budget | |||
November | December | ||
Cash disbursementsfor merchandise | $ | $ | |
Other monthly cashexpenses | |||
Total cashdisbursements | $ | $ | |
Cash balance,beginning | $ | $ | |
Add cashreceipts | |||
Total cashavailable | |||
Less cashdisbursement | |||
Excess (deficiency)of cash available over disbursements | |||
Financing | |||
Cash balance,ending | $ | $ | |
d. | Prepare Budgeted Income Statements for November and December.(Input all amounts as positive values. Omit the "$" sign inyour response.) |
Welnor Industrial Gas Corporation Budgeted Income Statement | ||
November | December | |
(Click toselect)Gross marginBad debt expenseSalesOther monthly expensesNetoperating incomeDepreciationCost of goods sold | $ | $ |
(Click toselect)Cost of goods soldSalesGross marginOther monthlyexpensesDepreciationNet operating incomeAccounts payable | ||
(Click toselect)Gross marginDepreciationCost of goods soldNet operatingincomeOther monthly expensesSalesAccounts payable | ||
(Click to select)Baddebt expenseSalesGross marginInventoryCost of goods soldAccountsreceivableAccounts payableNet operating incomeCash | ||
(Click toselect)Other monthly expensesInventoryCashAccounts payableSalesCostof goods soldOther monthly expensesAccounts receivableNet operatingincomeGross margin | ||
(Click toselect)CashAccounts receivableNet operating incomeSalesAccountspayableInventoryDepreciationCost of goods soldGross margin | ||
(Click to select)Netoperating incomeBad debt expenseCost of goods soldOther monthlyexpensesDepreciationGross marginSales | $ | $ |
e. | Prepare a Budgeted Balance Sheet for the end of December.(Be sure to enter your answers in the order of liquidity.Input all amounts as positive values. Omit the "$" sign in yourresponse.) |
Welnor Industrial Gas Corporation Budgeted Balance Sheet December 31 | ||
Assets | ||
(Click toselect)InventoryCashAccounts receivableProperty, plant andequipment | ||
(Click toselect)InventoryAccounts receivableProperty, plant andequipmentCash | ||
(Click toselect)InventoryCashProperty, plant and equipmentAccountsreceivable | ||
(Click toselect)Property, plant and equipmentAccountsreceivableCashInventory | ||
Total assets | ||
Liabilities and Stockholdersâ Equity | ||
(Click toselect)Accounts payableCashCommon stockRetained earnings | ||
(Click toselect)InventoryCashAccounts payableCommon stock | ||
(Click toselect)InventoryRetained earningsCashAccounts payable | ||
Total liabilitiesand stockholdersâ equity | ||