food beverage course please solve properly step by step 11 Month Operating Income StatementMonth End November 2022This MonthLast MonthYTDSalesFood%$429,617.00 $32,138.00 $ 341,264.00%247,631.00BeverageTotal SalesInventory AssetsFood$46,439.00$ 109,536.00$436,056.00 $39,769.00 $ 450,800.00%242$3,267.00 $2,679.00BeverageTotal Inventory On Hand463.00%24561.00%243,730.00 $3,240.00Controllable ExpensesFood PurchasesBeverage PurchasesSalaries and WagesEmployee BenefitsOther Controllable Expenses11365136241380163413,785.25 $2413,785.25 $ 151,637.7568.9368.93$48,340.0866,543.58$46,049.426,049.42$4Inventory AssetsFood%24%243,267.00 $463.00 $2,679.00561.00BeverageTotal Inventory On Hand%243,730.00%243,240.00Calculate UsageCOGS FoodCOGS BeverageLabor Cost %Prime Cost 9%Operating Income before Other ExpensesSSS

Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…

11 Month Operating Income Statement Month End November 2022 This Month Last Month YTD Sales Food %$4 29,617.00 $ 32,138.00 $ 341,264.00 7,631.00 Beverage %24 6,439.00 $ 24 109,536.00 Total Sales 24 36,056.00 $ 39,769.00 $ 450,800.00 Inventory Assets Food Beverage Total Inventory On Hand 2$ %$4 3,267.00 $ 2,679.00 561.00 463.00 %24 %24 3,730.00 %24 3,240.00 Controllable Expenses Food Purchases 11365 1380 13,785.25 $ 68.93 13624 Beverage Purchases Salaries and Wages Employee Benefits Other Controllable Expenses 1634 13,785.25 2$ 6,049.42 151,637.75 8,340.08 66,543.58 24 %24 6,049.42 68.93 24 %24 Inventory Assets Food 2$ 3,267.00 $ 463.00 Beverage 2,679.00 %24 2$ 561.00 Total Inventory On Hand %24 3,730.00 2$ 3,240.00 Calculate Usage COGS Food COGS Beverage Labor Cost % Prime Cost 9% Operating Income before Other Expenses

11 Month Operating Income Statement Month End November 2022 This Month Last Month YTD Sales Food %$4 29,617.00 $ 32,138.00 $ 341,264.00 7,631.00 Beverage %24 6,439.00 $ 24 109,536.00 Total Sales 24 36,056.00 $ 39,769.00 $ 450,800.00 Inventory Assets Food Beverage Total Inventory On Hand 2$ %$4 3,267.00 $ 2,679.00 561.00 463.00 %24 %24 3,730.00 %24 3,240.00 Controllable Expenses Food Purchases 11365 1380 13,785.25 $ 68.93 13624 Beverage Purchases Salaries and Wages Employee Benefits Other Controllable Expenses 1634 13,785.25 2$ 6,049.42 151,637.75 8,340.08 66,543.58 24 %24 6,049.42 68.93 24 %24 Inventory Assets Food 2$ 3,267.00 $ 463.00 Beverage 2,679.00 %24 2$ 561.00 Total Inventory On Hand %24 3,730.00 2$ 3,240.00 Calculate Usage COGS Food COGS Beverage Labor Cost % Prime Cost 9% Operating Income before Other Expenses

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 19E: Schedule of cash payments for service company Horizon Financial Inc. was organized on February 28....

See similar textbooks

Similar questions

Sales transactions Using transactions listed in P4-2, indicate the effects of each transaction on the liquidity metric working capital and profitability metric gross profit percent. Indicate the gross profit percent for each sale (rounding to one decimal place) in parentheses next to the effect of the sale on the company’s ability to attain an overall gross profit percent of 30%.
Schedule of cash payments for service company Horizon Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: Depreciation, insurance, and property taxes represent 9,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. Seventy percent of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule of cash payments for selling and administrative expenses for March, April, and May.
Ace Business Forms Month Current Assets Fixed Assets Total Assets January P125,000 P250,000 P375,000 February 130,000 250,000 380,000 March 135,000 250,000 385,000 April 150,000 250,000 400,000 May 150,000 250,000 400,000 June 125,000 250,000 375,000 July 115,000 250,000 365,000 August 120,000 250,000 370,000 September 115,000 250,000 370,000 October 100,000 250,000 350,000 November 110,000 250,000 360,000 December 115,000 250,000 365,000 Ace Business Forms has compiled several factors relative to its financing mix. The firm pays 8 percent on short-term funds and 10 percent on long-term funds. The firm’s monthly current, fixed and total asset requirements for the previous year are summarized in table above. Determine: a. the monthly average permanent funds requirement b. the monthly average seasonal funds requirement
Ace Business Forms Month Current Assets Fixed Assets Total Assets January P125,000 P250,000 P375,000 February 130,000 250,000 380,000 March 135,000 250,000 385,000 April 150,000 250,000 400,000 May 150,000 250,000 400,000 June 125,000 250,000 375,000 July 115,000 250,000 365,000 August 120,000 250,000 370,000 September 115,000 250,000 370,000 October 100,000 250,000 350,000 November 110,000 250,000 360,000 December 115,000 250,000 365,000 Ace Business Forms has compiled several factors relative to its financing mix. The firm pays 8 percent on short-term funds and 10 percent on long-term funds. The firm’s monthly current, fixed and total asset requirements for the previous year are summarized in table above. Determine: 1. the annual financing costs (aggressive strategy) 2. the annual financing costs (conservative strategy)
1. Year one income statement by months ( sales by year 3 $2.7m 2.7 m /3 = $900,000 average each year sales 900,000 / 12 = $75,000 sales each month Revenues: Net sales $75,000 each month Expenses and loses Costs of goods sold 1,786 x $15.60 = $27,863.78 Capital expenses $1,150 / 12= $95.83 Location expenses $76,415/ 12 = $6,367.92 Advertising / Promotional expenses $78,285/ 12 = $6,523.75 CalculateTotal expenses Depreciation expense is straight line for this project ?. Use the market value of the asset divided by monthly expected life of the asset, We will not use salvage value in calculating depreciation expense.
15. Selected information about income statement accounts for the Reed Company is presented below (the company's fiscal year ends on December 31): 2021 2020 Sales revenue $ 4,450,000 $ 3,550,000 Cost of goods sold 2,870,000 2,010,000 Administrative expense 810,000 685,000 Selling expense 370,000 312,000 Interest revenue 151,000 141,000 Interest expense 202,000 202,000 Loss on sale of assets of discontinued component 52,000 — On July 1, 2021, the company adopted a plan to discontinue a division that qualifies as a component of an entity as defined by GAAP. The assets of the component were sold on September 30, 2021, for $52,000 less than their book value. Results of operations for the component (included in the above account balances) were as follows: 1/1/2021–9/30/2021 2020 Sales revenue $ 410,000 $ 510,000 Cost of goods sold (295,000 ) (326,000 ) Administrative expense (51,000 )…
PROBLEM 14: MMM Company started operations in 2019. The following data are abstractedfrom the company’s production and sales records: 2019 2020 2021 Number of units produced 120,000 116,250 101,250 Number of units sold 75,000 108,750 97,500 Unit production cost P 4.50 P 5.20 P 5.80 Sales revenue 600,000 900,000 975,000 Using the FIFO cost flow assumption, the gross profit for the year ended December 31, 2021 is:
Year ended December 31, 2023 2022 2021 Revenues $4,578,041 $3,864,324 $3,003,610 Costs and expenses: Cost of goods sold $2,227,189 $2,089,089 $2,005,691 Selling and administrative 922,261 836,212 664,061 Interest 29,744 32,966 30,472 Other expenses (income) 1,475 2,141 (43) Total costs and expenses $3,180,669 $2,960,408 $2,700,181 Income before income taxes $1,397,372 $903,916 $303,429 Income taxes 229,500 192,600 174,700 Net income $1,167,872 $711,316 $128,729 Venus IndustriesConsolidated Balance Sheets (in thousands) December 31, ASSETS 2023 2022 Current assets: Cash and equivalents $291,284 $260,050 Accounts receivable, less allowance for doubtful accounts of $19,447 and $20,046 826,977 616,064 Inventories 592,986 512,917 Deferred income taxes 26,378 28,355 Prepaid expenses 40,663 32,977 Total current assets $1,778,288 $1,450,363 Property, plant, and equipment $571,032 $497,795 Less accumulated depreciation (193,037)…
CASE 1 The following are the information obtained from AMC Company:July August SeptemberCash Sales P24,000 P32,000 P36,000Credit Sales 220,000 300,000 240,000Purchases 180,000 240,000 220,000Operating Expenses 30,000 36,000 32,000Interest Expense - 4,000 -Credit sales are collected 50% in the month of sale, 40% in the month following, 8% in the second monthfollowing, and 2% uncollectible. Credit sales for May and June are expected to be P200,000 and P180,000,respectively. Purchases of merchandise, all on account, are paid 60% in the month of purchase and 40% in themonth following. Purchases for June are estimated at P160,000. Expenses include depreciation of P4,000monthly and are paid in the month incurred. The cash balance on June 30, 201A is P54,000.Required: Prepare a cash budget by month for the quarter ending September 30, 201A. Support your solutionwith schedules of cash receipts and cash payments CASE 2 Sanchez Company, a wholesaler, budgeted the following sales for the…
Reading readiness company Income statement For the month ended January 31, 20X1 Revenues: total revenues Expenses: Total Expenses
tion 8Income statement for the year ended 31 December, 2019 of KKMTN Ghana Ltd2018 2019ȼ ‘000 ȼ ‘000Turnover 420,000 523,600Cost of sales (330,000) (417,200)Gross profit 89,000 106,400Expenses:Administration 44,600 50,200Selling and distribution 15,400 (60,000) 19,600 (69,800)Profit before interest 29,000 36,600Debenture interest - (2,800)Net profit before tax 29,000 33,800Taxation (8,000) (10,000)Net Profit after tax 21,000 23,800Ordinary dividend paid 8,400 9,250Ordinary shares issued 12 million and trading at ȼ3 each as at yesterday onGSE.You are required to compute the following investment ratios:a). Earnings per shareb). Dividend per sharec). Payout ratiod). Price earnings ratioe). Earnings yield
Question 3 A Company has 20 days as average raw material inventory holding period (AAI), 15 days processing time, 10 days finished goods inventory holding time, 20 days’ average receivable collection period (ACP) and 30 days’ average payment period. The Company estimated for 2022 that raw material costs shall be $15 million, processing costs shall be $ 5 million, raw materials and finished goods holding costs shall be $3 million and marketing and collection costs shall be $1 million. Required a) Calculate the operating cycle (OC) and cash conversion cycle (CCC)? b) calculate working capital requirement of the company for 2022 assuming 365 days in a year?