Prepare a Sales Budget, Purchases Budget and Forecasted Income Statement for 2022 thirdquarter of Maryland Enterprises. Using the ff. data:JuneJulyAugustSeptemberUnits to be Sold1,0001,2501,5001,350Selling PriceP190Unit CostP120Beginning Inv for July100 unitsDesired Ending Inventory10% of Last month Unit Salesling ExpensesP25 per forecasted sales in unitsAdministrative ExpensesP10,000 per month

The production budget and sales budget are prepared to estimate the number of units to be produced…

Prepare a Sales Budget, Purchases Budget and Forecasted Income Statement for 2022 third quarter of Maryland Enterprises. Using the ff. data: June July August September Units to be Sold Selling Price Unit Cost 1,000 1,250 1,500 1,350 P190 P120 Beginning Inv for July 100 units Desired Ending Inventory Selling Expenses Administrative Expenses 10% of Last month Unit Sales P25 per forecasted sales in units P10,000 per month

Prepare a Sales Budget, Purchases Budget and Forecasted Income Statement for 2022 third quarter of Maryland Enterprises. Using the ff. data: June July August September Units to be Sold Selling Price Unit Cost 1,000 1,250 1,500 1,350 P190 P120 Beginning Inv for July 100 units Desired Ending Inventory Selling Expenses Administrative Expenses 10% of Last month Unit Sales P25 per forecasted sales in units P10,000 per month

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

Kindly help me answer the letters D & E. Thank you!
please dont provide answer in image format thank you
Function: SUM; Formula: Subtract, Multiply; Cell Referencing Using Excel to Prepare a Production Budget PROBLEM Paige Company estimates that following unit sales and desired inventory level for the four quarters of the year ending December 31, 2022. Quarter 1 sales Quarter 2 sales Quarter 3 sales Quarter 4 sales Desired ending finished goods inventory based on next quarter's expected unit sales Unit selling price 10,000 14,000 15,000 18,000 25% $ 70.00 Prepare a production budget by quarters for the first 6 months of 2022. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or this work area as indicated. Use the SUM function with cell referencing for totals. Paige Company Production Budget For the Six Months Ending June 30, 2022 Quarter 1 10,000 Expected unit sales Add: Desired ending finished goods units Total required units Less: Beginning finished goods units Required production…
Prepare a sales budget for 2 quarters Exercise 1 Trusler Electronics Inc. produces and sells two models of pocket calculators, XQ-103 and XQ-104. The sell for calculators $14.00 and $26.00 Trespectively. Because of the intense competition Trusler faces, management budgets sales semiannually. Its projections for the first 2 quarters of 2022 are as follows. Unit Sales Quarter 2 26,000 Product Quarter 1 ХО-103 21,000 ХО-104 13,000 16,000 No changes in selling prices are anticipated. Instructions: Prepare a sales budget for the 2 quarters ending June 30, 2022 using the below budget table. List the products and show for each quarter and for the 6 months, units, selling price, and total sales by product and in total. TRUSLER ELECTRONICS INC. Sales Budget For the Six Months Ending June 30, 2020 Quarter 1 Quarter 2 Six Months Product Selling Units Selling Price Total Sales Units Selling Price Total Sales Units Total Sales Price ХО-103 ХО-104 Totals
Please do not give solution in image format thanku
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 ?
Accounting Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 256,167 262,962 282,872 Credit Purchases 97,465 111,565 137,292 Wages, Taxes, and Expenses 26,506 31,621 33,707 Interest 7,239 7,773 8,091 Equipment Purchases 54,832 61,271 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the following month. Credit purchases will be paid in the month following the purchase. In June, credit sales were $138,282, and credit purchases were $102,770 July’s beginning cash is $184,797 If TAP maintains a policy of always keeping a minimum cash balance of $75,000 as a buffer against uncertainty and forecasting errors, what is the cash surplus/deficit at the end of the quarter (i.e., end of…
Do not give answer in image
both image are same please pull information and answer asap thanks
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,680 8,480 8,860 8,860 33,880 Direct material per unit 2 2 2 2 2 Total pounds needed for production 15,360 16,960 17,720 17,720 67,760 Add: Desired ending inventory 4,240 4,430 4,430 3,600 3,600 Total material required 19,600 21,390 22,150 21,320 71,360 Less: Beginning inventory 4,240 4,430 4,430 Pounds of direct material purchase requirements 19,600 17,150 17,720 16,890 71,360 Cost per pound $1.50 $1.50 $1.50 $1.50 $1.50 Total cost of direct material purchase $29,400 $25,725 $26,580 $25,335 $107,040 Total $107,040 Direct Labor Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,680 8,480 8,860 Direct labor hours per unit 0.75 0.75 0.75 0.75 0.75 Total required direct labor hours 5,760 6,360 6,645 6,645 Labor cost per hour $25 $25 $25 $25 $25 Total direct labor cost $144,000 $159,000 $166,125 $ $635,250
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…