The following data relate to theoperations of Picanuy Corporation, a wholesale distributor ofconsumer goods:
Current assets as ofDecember 31: Cash $ 6,000 Accounts receivable $ 39,360 Inventory $ 10,710 Buildings andequipment, net $ 112,700 Accountspayable $ 32,280 Capital stock $ 100,000 Retainedearnings $ 36,490
a. The gross margin is 30% ofsales. (In other words, cost of goods sold is 70% of sales.) b. Actual and budgeted sales dataare as follows:
December(actual) $65,600 January $76,500 February $88,700 March $92,200 April $60,500
c. Sales are 40% for cash and 60% on credit. Credit sales arecollected in the month following sale. The accounts receivable atDecember 31 are the result of December credit sales.
d. Each monthâs ending inventoryshould equal 20% of the following month's budgeted cost of goodssold. e. One-quarter of a monthâs inventory purchases is paid for in themonth of purchase; the other three-quarters is paid for in thefollowing month. The accounts payable at December 31 are the resultof December purchases of inventory.
f. Monthly expenses are as follows: commissions, $16,510; rent,$2,000; other expenses (excluding depreciation), 8% of sales.Assume that these expenses are paid monthly. Depreciation is $500for the quarter and includes depreciation on new assets acquiredduring the quarter.
g. Equipment will be acquired forcash: $3,790 in January and $8,990 in February. h. Management would like to maintain a minimum cash balance of$5,000 at the end of each month. The company has an agreement witha local bank that allows the company to borrow and repay inincrements of $1,000 at the beginning of each month, up to a totalloan balance of $50,000. The interest rate on these loans is 1% permonth, and for simplicity, we will assume that interest is notcompounded. The company would, as far as it is able, repay the loanplus accumulated interest at the end of the quarter.
Required: Using the dataabove: 1. Complete the following schedule:(Omit the "$" sign in your response.)
Schedule of Expected Cash Collections January February March Quarter Cash sales $30,600 $ $ $ Credit sales 39,360 Totalcollections $69,960 $ $ $
2. Complete the following: (Input all amounts as positivevalues. Leave no cells blank - be certain to enter "0" whereverrequired. Round the "Schedule of Expected Cash Disbursements âMerchandise Purchases" answers to 2 decimal places. Omit the "$"sign in your response.)
Merchandise Purchases Budget January February March Quarter Budgeted cost ofgoods sold $53,550 * $ $ $ Add desired endinginventory 12,418 â Total needs 65,968 Less beginninginventory 10,710 Requiredpurchases $55,258 $ $ $
*$76,500 sales à 70% =$53,550. â $88,700 à 70% à 20% =$12,418.
Schedule of Expected Cash DisbursementsâMerchandisePurchases January February March Quarter Decemberpurchases $32,280.00 * $ $ $32,280.00 Januarypurchases 13,814.50 41,443.50 55,258.00 Februarypurchases March purchases Totaldisbursements $46,094.50 $ $ $
*Beginning balance of theaccounts payable.
3. Complete the following schedule:(Omit the "$" sign in your response.)
Schedule of Expected Cash DisbursementsâSelling andAdministrative Expenses January February March Quarter Commissions $16,510 $ $ $ Rent 2,000 Other expenses 6,120 Totaldisbursements $24,630 $ $ $
4. Complete the following cash budget: (Borrow and repay inincrements of $1,000. Input all amounts as positive values exceptcash deficiency, repayments and interest which should be indicatedby a minus sign. Round your answers to 2 decimal places. Leave nocells blank - be certain to enter "0" wherever required. Omit the"$" sign in your response.)
Picanuy Corporation Cash Budget January February March Quarter Cash balance,beginning $ 6,000.00 $ $ $ Add cashcollections 69,960.00 Total cashavailable 75,960.00 Less cashdisbursements: Forinventory 46,094.50 Foroperating expenses 24,630.00 Forequipment 3,790.00 Total cashdisbursements 74,514.50 Excess (deficiency)of cash 1,445.50 Financing: Borrowings Repayments Interest Total financing Cash balance,ending $ $ $ $
5. Prepare an absorption costing income statement for the quarterended March 31. (Input all amounts as positive values. Omitthe "$" sign in your response.)
Picanuy Corporation
Income Statement
For the Quarter Ended March 31 (Click toselect)SalesGoods available for saleOther expensesNet operatingincome (loss)Gross marginBeginning inventoryNet income (loss)Endinginventory $ Cost of goodssold: (Click to select)Goodsavailable for saleDepreciationNet operating income (loss)BeginninginventoryPurchasesOther expensesEnding inventoryGross margin $ (Click to select)Netoperating income (loss)DepreciationGross marginPurchasesInterestexpensesSalesEnding inventoryOther expenses (Click toselect)DepreciationNet operating income (loss)PurchasesOtherexpensesBeginning inventorySalesGross marginGoods available forsale (Click to select)InterestexpensesGross marginDepreciationEnding inventoryBeginninginventoryNet operating income (loss)PurchasesOther expenses (Click toselect)Beginning inventoryInterest expenseNet operating income(loss)Goods available for saleGross marginNet income(loss)PurchasesSales Selling andadministrative expenses: (Click to select)GrossmarginRentOther expensesBeginning inventoryNet operating income(loss)DepreciationCommissionsGoods available for sale (Click to select)Goodsavailable for saleGross marginNet operating income(loss)DepreciationRentBeginning inventoryOtherexpensesCommissions (Click toselect)CommissionsGoods available for saleNet operating income(loss)DepreciationRentBeginning inventoryGross marginOtherexpenses (Click toselect)Beginning inventoryGross marginOther expensesNet operatingincome (loss)DepreciationCommissionsGoods available forsaleRent (Click toselect)Ending inventoryGross marginGoods available forsaleDepreciationSalesNet operating income(loss)PurchasesCommissions (Click toselect)DepreciationNet operating income (loss)SalesBeginninginventoryEnding inventoryOther expensesGross marginInterestexpense (Click toselect)SalesGoods available for saleGross marginDepreciationOtherexpensesNet income (loss)Interest expenseEnding inventory $
6. Prepare a balance sheet as ofMarch 31. (Be sure to list the assets and liabilities inorder of their liquidity. Round your answers to 2 decimal places.Omit the "$" sign in your response.)
Picanuy Corporation
Balance Sheet
March 31 Assets Current assets: (Click to select)Fixedassets-netAccounts payableCashAccounts receivableInventory $ (Click to select)AccountspayableFixed assets-netCashAccounts receivableInventory (Click to select)AccountspayableFixed assets-netAccounts receivableCashInventory Total currentassets (Click toselect)Accounts receivableInventoryCashAccounts payableFixedassets-net Total assets $ Liabilities and Stockholdersâ Equity (Click toselect)Accounts payableCapital stockRetained earningsBank loanpayableAccounts receivable $ (Click toselect)Bank loan payableAccounts receivableRetainedearningsAccounts payableCapital stock Stockholders'equity: (Click to select)AccountspayableCashCapital stockAccounts receivableBank loan payable $ (Click to select)Bankloan payableCashAccounts payableRetained earningsAccountsreceivable Total liabilitiesand stockholders' equity $
Need help with 5 and 6 .....
The following data relate to theoperations of Picanuy Corporation, a wholesale distributor ofconsumer goods: |
Current assets as ofDecember 31: | ||
Cash | $ | 6,000 |
Accounts receivable | $ | 39,360 |
Inventory | $ | 10,710 |
Buildings andequipment, net | $ | 112,700 |
Accountspayable | $ | 32,280 |
Capital stock | $ | 100,000 |
Retainedearnings | $ | 36,490 |
a. | The gross margin is 30% ofsales. (In other words, cost of goods sold is 70% of sales.) |
b. | Actual and budgeted sales dataare as follows: |
December(actual) | $65,600 |
January | $76,500 |
February | $88,700 |
March | $92,200 |
April | $60,500 |
c. | Sales are 40% for cash and 60% on credit. Credit sales arecollected in the month following sale. The accounts receivable atDecember 31 are the result of December credit sales. |
d. | Each monthâs ending inventoryshould equal 20% of the following month's budgeted cost of goodssold. |
e. | One-quarter of a monthâs inventory purchases is paid for in themonth of purchase; the other three-quarters is paid for in thefollowing month. The accounts payable at December 31 are the resultof December purchases of inventory. |
f. | Monthly expenses are as follows: commissions, $16,510; rent,$2,000; other expenses (excluding depreciation), 8% of sales.Assume that these expenses are paid monthly. Depreciation is $500for the quarter and includes depreciation on new assets acquiredduring the quarter. |
g. | Equipment will be acquired forcash: $3,790 in January and $8,990 in February. |
h. | Management would like to maintain a minimum cash balance of$5,000 at the end of each month. The company has an agreement witha local bank that allows the company to borrow and repay inincrements of $1,000 at the beginning of each month, up to a totalloan balance of $50,000. The interest rate on these loans is 1% permonth, and for simplicity, we will assume that interest is notcompounded. The company would, as far as it is able, repay the loanplus accumulated interest at the end of the quarter. |
Required: | |
Using the dataabove: | |
1. | Complete the following schedule:(Omit the "$" sign in your response.) |
Schedule of Expected Cash Collections | ||||
January | February | March | Quarter | |
Cash sales | $30,600 | $ | $ | $ |
Credit sales | 39,360 | |||
Totalcollections | $69,960 | $ | $ | $ |
2. | Complete the following: (Input all amounts as positivevalues. Leave no cells blank - be certain to enter "0" whereverrequired. Round the "Schedule of Expected Cash Disbursements âMerchandise Purchases" answers to 2 decimal places. Omit the "$"sign in your response.) |
Merchandise Purchases Budget | |||||
January | February | March | Quarter | ||
Budgeted cost ofgoods sold | $53,550 | * | $ | $ | $ |
Add desired endinginventory | 12,418 | â | |||
Total needs | 65,968 | ||||
Less beginninginventory | 10,710 | ||||
Requiredpurchases | $55,258 | $ | $ | $ | |
*$76,500 sales à 70% =$53,550. |
â $88,700 Ã 70% Ã 20% =$12,418. |
Schedule of Expected Cash DisbursementsâMerchandisePurchases | ||||||||
January | February | March | Quarter | |||||
Decemberpurchases | $32,280.00 | * | $ | $ | $32,280.00 | |||
Januarypurchases | 13,814.50 | 41,443.50 | 55,258.00 | |||||
Februarypurchases | ||||||||
March purchases | ||||||||
Totaldisbursements | $46,094.50 | $ | $ | $ | ||||
*Beginning balance of theaccounts payable. |
3. | Complete the following schedule:(Omit the "$" sign in your response.) |
Schedule of Expected Cash DisbursementsâSelling andAdministrative Expenses | ||||
January | February | March | Quarter | |
Commissions | $16,510 | $ | $ | $ |
Rent | 2,000 | |||
Other expenses | 6,120 | |||
Totaldisbursements | $24,630 | $ | $ | $ |
4. | Complete the following cash budget: (Borrow and repay inincrements of $1,000. Input all amounts as positive values exceptcash deficiency, repayments and interest which should be indicatedby a minus sign. Round your answers to 2 decimal places. Leave nocells blank - be certain to enter "0" wherever required. Omit the"$" sign in your response.) |
Picanuy Corporation | ||||
Cash Budget | ||||
January | February | March | Quarter | |
Cash balance,beginning | $ 6,000.00 | $ | $ | $ |
Add cashcollections | 69,960.00 | |||
Total cashavailable | 75,960.00 | |||
Less cashdisbursements: | ||||
Forinventory | 46,094.50 | |||
Foroperating expenses | 24,630.00 | |||
Forequipment | 3,790.00 | |||
Total cashdisbursements | 74,514.50 | |||
Excess (deficiency)of cash | 1,445.50 | |||
Financing: | ||||
Borrowings | ||||
Repayments | ||||
Interest | ||||
Total financing | ||||
Cash balance,ending | $ | $ | $ | $ |
5. | Prepare an absorption costing income statement for the quarterended March 31. (Input all amounts as positive values. Omitthe "$" sign in your response.) |
Picanuy Corporation Income Statement For the Quarter Ended March 31 | ||
(Click toselect)SalesGoods available for saleOther expensesNet operatingincome (loss)Gross marginBeginning inventoryNet income (loss)Endinginventory | $ | |
Cost of goodssold: | ||
(Click to select)Goodsavailable for saleDepreciationNet operating income (loss)BeginninginventoryPurchasesOther expensesEnding inventoryGross margin | $ | |
(Click to select)Netoperating income (loss)DepreciationGross marginPurchasesInterestexpensesSalesEnding inventoryOther expenses | ||
(Click toselect)DepreciationNet operating income (loss)PurchasesOtherexpensesBeginning inventorySalesGross marginGoods available forsale | ||
(Click to select)InterestexpensesGross marginDepreciationEnding inventoryBeginninginventoryNet operating income (loss)PurchasesOther expenses | ||
(Click toselect)Beginning inventoryInterest expenseNet operating income(loss)Goods available for saleGross marginNet income(loss)PurchasesSales | ||
Selling andadministrative expenses: | ||
(Click to select)GrossmarginRentOther expensesBeginning inventoryNet operating income(loss)DepreciationCommissionsGoods available for sale | ||
(Click to select)Goodsavailable for saleGross marginNet operating income(loss)DepreciationRentBeginning inventoryOtherexpensesCommissions | ||
(Click toselect)CommissionsGoods available for saleNet operating income(loss)DepreciationRentBeginning inventoryGross marginOtherexpenses | ||
(Click toselect)Beginning inventoryGross marginOther expensesNet operatingincome (loss)DepreciationCommissionsGoods available forsaleRent | ||
(Click toselect)Ending inventoryGross marginGoods available forsaleDepreciationSalesNet operating income(loss)PurchasesCommissions | ||
(Click toselect)DepreciationNet operating income (loss)SalesBeginninginventoryEnding inventoryOther expensesGross marginInterestexpense | ||
(Click toselect)SalesGoods available for saleGross marginDepreciationOtherexpensesNet income (loss)Interest expenseEnding inventory | $ | |
6. | Prepare a balance sheet as ofMarch 31. (Be sure to list the assets and liabilities inorder of their liquidity. Round your answers to 2 decimal places.Omit the "$" sign in your response.) |
Picanuy Corporation Balance Sheet March 31 | ||
Assets | ||
Current assets: | ||
(Click to select)Fixedassets-netAccounts payableCashAccounts receivableInventory | $ | |
(Click to select)AccountspayableFixed assets-netCashAccounts receivableInventory | ||
(Click to select)AccountspayableFixed assets-netAccounts receivableCashInventory | ||
Total currentassets | ||
(Click toselect)Accounts receivableInventoryCashAccounts payableFixedassets-net | ||
Total assets | $ | |
Liabilities and Stockholdersâ Equity | ||
(Click toselect)Accounts payableCapital stockRetained earningsBank loanpayableAccounts receivable | $ | |
(Click toselect)Bank loan payableAccounts receivableRetainedearningsAccounts payableCapital stock | ||
Stockholders'equity: | ||
(Click to select)AccountspayableCashCapital stockAccounts receivableBank loan payable | $ | |
(Click to select)Bankloan payableCashAccounts payableRetained earningsAccountsreceivable | ||
Total liabilitiesand stockholders' equity | $ | |
Need help with 5 and 6 ..... |