
| Sales revenue | 31700 | 36800 | 40400 |
| Cost of goods sold | |||
| Inventory, beginning | 25800 | 25200.00 | 29300 |
| Purchases | 20900 | 24900 | 26600 |
| Cost of goods available | 46700 | 50100 | 55900 |
| Inventory, ending | 25200.00 | 29300 | 23200 |
| Cost of goods sold | 21500.00 | 20800.00 | 32700.00 |
| Gross Profit | 10200.00 | 16000.00 | 7700.00 |
| Gain (loss) due to market fluctuations | -7000 | 1700 | 300 |
| 3200.00 | 17700.00 | 8000 |
| Date | Accounts | Debit | Credit |
| Jan 31 | Loss due to decline of inventory to NRV | 1100 | |
| Allowance to reduce inventory to NRV | 1100 | ||
| Feb 28 | Loss due to decline of inventory to NRV | 7000 | |
| Allowance to reduce inventory to NRV | 7000 | ||
| Mar 31 | Allowance to reduce inventory to NRV | 1700 | |
| Recovery of inventory loss | 1700 | ||
| Apr 30 | Allowance to reduce inventory to NRV | 300 | |
| Recovery of inventory loss | 300 |
prepare the monthly income statement in columnar format for Feb, Mar and Apr following the format, also prepare the jou...
Presented below is information related to Bramble Enterprises. Jan. 31 Feb. 28 Mar. 31 Apr. 30 Inventory at cost $17,100 $17,214 $19,380 $15,960 Inventory at LCNRV 16,530 14,364 17,784 15,162 Purchases for the month 19,380 27,360 30,210 Sales for the month 33,060 39,900 45,600 (a) From the information, prepare (as far as the data permit) monthly income statements in columnar form for February, March, and April. The inventory is to be shown in the statement at cost; the gain or...
Jan 31 ?Feb 28 Mar 31 Apr 30 Inventory at cost 15,000 15,100 17,000 14,000 Inventory at LCNRV 14,500 12,600 15,600 13,300 Purchases for the month 17,000 24,000 26,500 Sales for the month 29,000 35,000 40,000 (a) From the information, prepare (as far as the data permit) monthly income statements in columnar form for February, March, and April. The inventory is to be shown in the statement at cost; the gain or loss due to market fluctuations is to be...
Presented below is information related to Windsor
Enterprises.
Jan. 31
Feb. 28
Mar. 31
Apr. 30
Inventory at cost
$16,800
$16,912
$19,040
$15,680
Inventory at LCNRV
16,240
14,112
17,472
14,896
Purchases for the month
19,040
26,880
29,680
Sales for the month
32,480
39,200
44,800
Prepare the journal entry required to establish the valuation
account at January 31 and entries to adjust it monthly thereafter.
(Credit account titles are automatically indented when
amount is entered. Do not indent manually. If no...
Prepare cash budget using following information: Sales Jan 80,000 Feb 75,000 Mar 92,000 April 88,000 May 76,000 June 81,000 The selling price was set to offer 15% margin on the purchase price of the goods. The company has a policy to keep a monthly closing balance of inventory as 50% of the requirement of the next month. Beginning inventory for the month of Jan is $43,500 and ending inventory of June is $39,200. The...
Tuscarora, Inc., a merchandising company, has the following budgeted figures: Jan Feb Mar April Sales $54,400.00 $64,000.00 $88,000.00 $94,000.00 Cost of goods sold 60% of sales Required ending inventory $15,000.00 +25%of nextmonth's sales Inventory on hand on Jan 1 $27,000.00 Calculate the budgeted purchases for the month of January. and also, Arianell, Inc. reports the following information for August: Sales Revenue $800,000 Variable Cost of Goods Sold 170,000 Fixed Cost of Goods Sold 45,000 Variable Selling and Administrative Costs 150,000...
Presented below is information related to Bramble Enterprises. Jan. 31 Feb. 28 Mar. 31 Apr. 30 Inventory at cost $17,100 $17,214 $19,380 $15,960 Inventory at LCNRV 16,530 14,364 17,784 15,162 Purchases for the month 19,380 27,360 30,210 Sales for the month 33,060 39,900 45,600 February March April select an income statement item Cost of Goods AvailableCost of Goods SoldFreight-inGain (loss) due to Market Fluctuations of InventoryGross...
*Exercise 9-05 Presented below is information related to Sheffield Enterprises. Jan. 31 $17,550 16,965 Inventory at cost Inventory at LCNRV Purchases for the month Sales for the month Feb. 28 $17,667 14,742 19,890 33,930 Mar. 31 $19,890 18,252 28,080 40,950 Apr. 30 $ 16,380 15,561 31,005 46,800 From the information, prepare (as far as the data permit) monthly income statements in columnar form for February, March, and April. The inventory is to be shown in the statement at cost; the...
MUST SHOW ALL CELL FORMULAS
Required: You need to prepare a comprehensive
12-month budget, including supporting schedules and a report for
the period January 1, 2020 to December 31, 2020 for Hedron,
Inc.
INFORMATION FOR HEDRON, INC.
Hedron, Inc. is a company that re-sells one product, a
particularly comfortable lawn chair. An overseas contractor makes
the product exclusively for Hedron, so Hedron has no manufacturing
related costs.
PRODUCT COSTS
In Nov of 2019, each lawn chair costs
Hedron $4 per...
INSTRUCTIONS:
Based on the information available below, complete the
Cash Budget, Income Statement, and Budgeted Balance Sheet
worksheet
4 A relatively new company, Get Laughy Taffy, Inc., has determined they need to engage in a budgeting 5 process as part of their new strategic plan. The Company has asked you to provide the following items 6 for the months of January, February, and March of 2020: A) a Purchases Budget; B) a Cash Budget; C) a 7 Budgeted Income Statement;...
YOUR COMPANY
Income Statement
For the year ended January 31, 2019
Sales revenue (net)
55,432
Cost of goods sold
-9,778
Gross profit
45,704
Operating expenses:
Selling expenses
2,598
General & administrative expenses
25,869
Depreciation expense
8,548
Total operating expenses
38,015
Operating Income
9,089
Other items:
Interest expense
-3,253
Loss on sale of equipment
625
3,878
Net Income
4,811
YOUR COMPANY
Statement of Cash Flows
For the year ended January 31st, 2019
Cash Flows from Operating Activities
Net Income
Adjustments for...