The data shown were obtained from the financial records of Italian Exports, Inc., for March:Estimated SalesSalesPurchasesEnding Inventory*Administrative SalariesMarketing Expense**Sales CommissionsRent ExpenseDepreciation ExpenseUtilitiesTaxes****of next month's sales**of estimated salesSalesCost of Goods Sold***of income before taxesSales are expected to increase each month by 10%.Prepare a budgeted Income statement. Round your answers to the nearest dollar.Italian Exports, Inc.Budgeted Income StatementFor the Month Ending Mar. 31, 2020Beginning InventoryPurchasesCost of Goods Avaliable for SaleEnding InventoryCost of Goods SoldGross ProfitOperating ExpensesAdministrative SalariesMarketing ExpensesSales CommissionsRent ExpenseDepreciation Expense$340,000367,932294,830UtilitiesTotal Operating ExpensesIncome From OperationsIncome Tax ExpenseNet Income10%30,3405%2%7,0009002,30015%to ovembo

Income statement refers to the statement which is prepared by the business at the end of the period…

Estimated Sales Sales Purchases Ending Inventory Administrative Salaries Marketing Expense** Sales Commissions Rent Expense Depreciation Expense $540,000 307,932 294,830 10% 30,340 5% 7,000 900 Utilities Taxes*** *of next month's sales **of estimated sales ***of income before taxes Sales are expected to increase each month by 10%. Prepare a budgeted income statement. Round your answers to the neares 2,300 15%

Estimated Sales Sales Purchases Ending Inventory Administrative Salaries Marketing Expense Sales Commissions Rent Expense Depreciation Expense $540,000 307,932 294,830 10% 30,340 5% 7,000 900 Utilities Taxes* of next month's sales of estimated sales of income before taxes Sales are expected to increase each month by 10%. Prepare a budgeted income statement. Round your answers to the neares 2,300 15%

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

In September 2019, the budget committee of Jason Company assembles the following data: 1. 2 Expected Sales 4. October November December Cost of goods sold is expected to be 60% of sales. 3. Desired ending merchandise inventory is 20% of the next month's cost of goods sold. The beginning inventory at October 1 will be the desired amount. $1,800,000 1,700,000 V 1,600,000 Prepare the budgeted income statement for October through gross profit on sales, including a cost of goods sold schedule. V M JASON COMPANY Budgeted Income Statement For the Month Ended October 31, 2019 $ $
Part A: Use a spreadsheet to prepare a monthly personal budget to show the available surplus based on the following data. ➤ Monthly salary is QAR 14,600. ➤ Monthly rental expense is QAR 6,650. 19tn3. onidiol ➤ Food expenses are QAR 250 per week. ➤ Electricity is estimated to be QAR 50 per month. ➤ Ooredoo unlimited usage telephone plan is QAR 320 per month. Entertainment is estimated to be QAR 500 per week. ➤Clothing expenses are estimated to be QAR 5,000 per year. Fuel QAR 50 per week. ➤Insurance QAR 2,460 per year. ➤ Vehicle maintenance QAR 2,000 per year. ➤You decide that you must leave a budgeted surplus of QAR 1,000 per month to cover unexpected expenses.
Center Company makes collections on sales according to the following schedule: 30% in the month of sale 60% in the month following sale 8% in the second month following sale The following sales are expected: Expected Sales January $117,000 February $152,000 March $132,000 Cash collections in March should be budgeted to be: Multiple Choice $130,800. $133.200. $140.160. $132,000.
1. WFU Corporation expects the unit sales of Product MSA to increase by 10%, while Product MA will increase by 5% of last year's sales. The company will increase the price of Product MSA by $10, while Product MA will remain the same. Prepare the budgeted revenue for the upcoming year, 20Y6 with the information below for 20Y5. Product MSA Product MA 2. WFU Corporation has a desired ending inventory of 5% of the upcoming year's sales for each year. In 20Y7, the company expects to sell 20,000 of Product MSA and 12,000 of Product MA. Prepare the company's production budget for 2016. 3. Each finished good of Product MSA and Product MA requires two materials, Product M and Product A, which are measured in pounds. Product M costs $7.50 per pound, and Product A costs $5.00 per pound. The required pounds of material per finished good and beginning and ending inventories are shown. Prepare the 20Y6 direct materials purchases budget. Product MSA Product MA Beginning inventory Ending inventory…
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. January February⚫ March Cash Receipts Cash payments $ 521,000 408,000 457,000 $ 467,800 354,800 522,000 Kayak requires a minimum cash balance of $50,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $50,000 is used to repay loans at month-end. The company has a cash balance of $50,000 and a loan balance of $100,000 at January 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.)
Budgeted Selling and Administrative Expenses Salary Expense Sales Commissions 5% of Sales Insurance Expense Rent Depreciation on equipment Utilities Total Operating Expenses Schedule of Cash Payments for Selling and Administrative Expenses Salary Expense 100% of Prior Month Sales Commissions Insurance Expense October November December Multiple Choice 30,000 30,500 15,000 15,500 12,000 12,000 14,400 14,400 16,500 16,500 2,100 2,300 90,000 91, 200 ? 15,100 12,000 ? 2,200 ? 30,500 ? 12,000 ? ? ? Rent 100% of Prior Months Utilities Expense Total Payments for Selling and Administrative Expenses The amount of cash paid for Selling and Administrative expenses during the month of November is: 31,000 15,300 12,000 14,400 16,500 2,500 91,700 ? ? 12,000 14,400 ?
Question 1 The following data apply to the HASF Hardware Store and its 2011 budget Forecast Sales Jan $200,000 Feb $160,000 Mar $180,000 Apr $45,000 Balance Sheet Data December 31,2010 Cash $80,000 Account receivable: November sales 45000 December sales 50000 Inventory 54000 Account payable(merchandise) 27000 Other data are as follows: Sales are on credit with 60% of sales collected in the same month after sale ,40% in the second month after sale Cost of goods sold is 50% of sales Other variables costs are 30% of sales paid in the month incurred Inventories are to be 80% of next month’s budgeted sales requirements Fixed expenses are $15000 per month; all require cash Credit time period for purchases are 30 days On basis of above information answer following questions Find fixed expense in the month of March?
Schedules of Expected Cash Collections and Disbursements; Budgeted Income Statement and Budgeted Balance Sheet. Crow Enterprises is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Crow Enterprises Balance Sheet June 30 Assets $ 80,000 135,000 41,250 Plant and equipment, net of depreciation_211,000 $ 457,250 Cash Accounts receivable Inventory Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings $ 72,000 345,000 50,250 Total liabilities and stockholders' equity $ 467,250 Crow's managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August, September, and October will be $220,000, $240,000, $230,000, and $250,000, respectively. 2. All sales are on credit and all credit sales are collected. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the…
Infinity Inc. has provided the following projected sales units for the next quarter: Projected Sales Units First month Second month Third month Projected sales units 10,000 12,000 15,000 Desired ending inventory is determined to be 10% of the next month’s projected sales. The expected purchase cost per unit is $50. Compute the budgeted Costs of goods sold for the next quarter. Group of answer choices $1,850,000 $600,000 $500,000 $750,000
Concord Company estimates that 2022 sales will be $34,400 in quarter 1, $41,280 in quarter 2, and $49,880 in quarter 3. Cost of goods sold is 50% of sales. Management desires to have ending merchandise inventory equal to 10% of the next quarter's expected cost of goods sold. Prepare a merchandise purchases budget by quarter for the first 6 months of 2022. v: v ✓ CONCORD COMPANY Merchandise Purchases Budget $ $ 1 Quarter $ $ 2 $ Six Months
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 526,000 $ 472,800 February 412,000 358,800 March 459,000 528,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $30,000 is used to repay loans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.
Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2020: April May June Credit sales $ 312,000 $ 292,000 $ 352,000 Credit purchases 120,000 143,000 168,000 Cash disbursements Wages, taxes, and expenses 43,200 10,700 62,200 Interest 10,200 10,200 10,200 Equipment purchases 72,000 134,000 0 The company predicts that 5 percent of its credit sales will never be collected, 40 percent of its sales will be collected in the month of the sale, and the remaining 55 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2020, credit sales were $182,000, and credit purchases were $122,000. Using this information, complete the following cash budget. (Do not round intermediate calculations.)