Oriole, Inc. provided the following budgeted information for
March through July:
March | April | May | June | July | |
Projected sales | $104100 | $122800 | $114600 | $131600 | $141000 |
Projected merchandise purchases | $81700 | $92600 | $75300 | $66000 | $73100 |
Inventory at end of month | $11800 | $13900 | $12000 | $12500 | $14100 |
How much is budgeted net income for May?
Budgeted net income for May = $3,780
Working
Oriole, Inc | ||
Income Statement | ||
For May | ||
Sales | $ 1,14,600.00 | |
Cost Of goods sold | ||
Finished goods Inventory, beginning | $ 13,900.00 | |
Purchases | $ 75,300.00 | |
Cost of Goods Available for sale | $ 89,200.00 | |
Less: Finished goods Inventory, Ending | $ 12,000.00 | |
Cost of Goods sold | $ 77,200.00 | |
Gross Profit | $ 37,400.00 | |
Operating Expenses | $ 31,100.00 | |
Total Operating expense | $ 6,300.00 | |
Income tax expense (40%) | $ 2,520.00 | |
Net income | $ 3,780.00 |
Oriole, Inc. provided the following budgeted information for March through July: March April ...
9.7 Budgeted cash disbursements Burr, Inc. provided the following information: __ July August Projected sales $220,000 $260,000 Projected merchandise purchases $150,000 $180,000 • Burr estimates that it will collect 40% of its sales in the month of sale, 35% in the month after the sale, and 22% in the second month following the sale. Three percent of all sales are estimated to be bad debts. • Burr pays 30% of merchandise purchases in the month purchased and 70% in the...
The following credit sales are budgeted by Swifty Electronics: January $123500 February 119900 March 134400 April 141000 May 141200 The company's past experience indicates that 45% of the accounts receivable are collected in the month of sale, 35% in the month following the sale, and 19% in the second month following the sale. 1 percent are uncollectible. How much does the company anticipate as cash receipts for March? $133056 $125910 $136658 $123076
Please show full calculations for each. Thanks! 1) ABC Company's budgeted sales are as follows: July = 3,000 units; August = 2,500 units. June ending inventory = 1,200 units. Budgeted ending inventory must equal 40% of next month's budgeted sales. Production budgeted for July would equal units = ? units ------ 2) ABC Company's budgeted production is as follows: January = 5,000 units; February = 8,000 units. Each unit produced requires 3 pounds of raw material. January beginning inventory...
Casa Development, Inc. has budgeted sales revenues as follows: January February March April May June Budgeted Sales Revenues $55,000 75,000 90,000 80,000 60,000 35,000 Past experience has indicated that 80% of sales each month are on credit and that collection of credit sales occurs as follows: 60% in the month of sale, 30% in the month following the sale, and 5% in the second month following the sale. The other 5% is uncollectible. Prepare a schedule which shows expected cash...
Question : 1 Budgeted Sales April (Actual) S7200,000 May 8400,000 June 1 020,000 July 1.080,000 August 600,000 September 900,000 Additional information Cash Sales 40% Credit sales (Collected the following month) 60% Prepare Sales Budget and Cash Collection from customers from May to August Solution: Schedule a Sales Budget Code Sales Schedule b. Cash Collection from Customers Collection Price month Tool Collection Question-2: A manufacturing Company provided the following information Budgeted Sales December (Actual) S480,000 January 560,000 February 680,000 March 720,000...
Ivory Inc. has forecast purchases on account to be $310,000 in March, $370,000 in April, $420,000 in May, and $490,000 in June Seventy percent of purchases are paid for in the month of purchase, the remaining 30% are paid in the following month. What are budgeted cash payments for June? Multiple Choice Ο Ο 5294000 Ο Ο 5460.000 Ο Ο 5343,000 Ο Ο 421000 Walnut has forecast sales for the next three months as follows: July 4,000 units, August 6,000...
Following are the budgeted income statements for the second quarter of 2019 for SeaTech Inc.: April May June Sales $ 210,000 $ 255,000 $ 285,000 Cost of goods sold* 144,000 171,000 189,000 Gross profit $ 66,000 $ 84,000 $ 96,000 Operating expenses† 33,000 37,500 40,500 Operating income $ 33,000 $ 46,500 $ 55,500 * Includes all product costs (i.e., direct materials, direct labor, and manufacturing overhead). † Includes all period costs (i.e., selling, general, and administrative expenses). The company expects...
a. Budgeted monthly absorption costing income statements for April-July are: April May June July $ 470,000 $1,000,000 $450,000 $ 350,000 329,000 700,000 315,000 245,000 141,000 300,000 135,000 105,000 Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense Total selling and administrative expenses Net operating income 91,000 42,500 133,500 7,500 $ 95,000 56,800 151,800 148,200 $ 56,000 35,000 9 1,000 44,000 $ 35,000 33,000 68,000 37,000 $ *Includes $17,000 of depreciation each month. b. Sales...
Soup Inc. has the following budgeted sales: January $60,000, February $80,000, and March $90,000. 40% of the sales are for cash and 60% are on credit. For the credit sales, 75% are collected in the month of sale, and 25% the next month. The total budgeted cash receipts for March are:
A company budgeted the following purchases for raw materials: Month January February March April May June July Budget $10,000 $20,000 $25,000 $22,000 $27,000 $30,000 $24,000 The company has a policy of paying for 40% of the purchases in the month of purchase, 35% in the month following the purchase, and 25% in the second month following the purchase. Based on this information, what are the budgeted cash disbursements for May?