ACTUAL OPERATING RESULTS CURRENT MONTH Revenue Source Number of Guests Restaurant Lounge Banquet room Total 3492 515 388 4395 Average Sale per Guest $20.50 $12.00 $28.50 $20.21 Sales $71,586 $6,180 $11,058 $88,824 Create the revenue forecast for next month based on the following assumptions. A. Restaurant guest counts will be 3,600 with an average sale per guest of $21.00. B. Lounge guests to be served are estimated at 525 with a 10 percent increase in average

ACTUAL OPERATING RESULTS CURRENT MONTH Revenue Source Number of Guests Restaurant Lounge Banquet room Total 3492 515 388 4395 Average Sale per Guest $20.50 $12.00 $28.50 $20.21 Sales $71,586 $6,180 $11,058 $88,824 Create the revenue forecast for next month based on the following assumptions. A. Restaurant guest counts will be 3,600 with an average sale per guest of $21.00. B. Lounge guests to be served are estimated at 525 with a 10 percent increase in average

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

Catulla Corporation predicts the following sales in units for the coming four months April May 240 200 June July 300 sales in units Each moners ending Finished Goods Inventory in units should be 40% of the next month's sales Mech 21 Fished Goods inventory a 00 unts A freshed unit requires five pounds of dract material 8 at a cost of $2.00 per pound. The March 31 Raw Materials inventory has 200 pounds of direct matal 8. Each moners ending Raw Materials twentary should be 30% of the following months production needs The budgeted purchases of pounds of direct material during May should be O 1422 pounds 4xpr 210 pan
Financial Report for Store: A typical annual income statement for a pre-plan Ladbreck store before fixed charges, taxes, and incidentals looks as follows. Sales... Cost of goods sold. Gross profit.... Employee salaries. Profit before fixed charges.. Total 10,000,000 6,300,000 3,700,000 800,000 2,900,000 Percent 100 63 37 8 29 A store also has substantial charges for rent, management salaries, insurance, etc., but they are fixed with respect to the incentive plan. Required a. Suppose the goal of the firm is to now provide superior customer service by having the sales con- sultant identify and sell to the specific needs of the customer. What does this goal suggest about a change in managerial accounting and control systems? b. Provide an estimate of the impact of the incentive plan on sales. c. Did the sales impact occur all at once, or did it occur gradually?
Neon Inc.’s forecast sales for July is $72,000. It has $15,000 in accounts receivable at the end of June. 30% of its total sales are expected to be cash sales. Of the remaining 70%, 80% are expected to be collected in the month of the sale and the remaining 20% in the month following the sale. Determine the amount of accounts receivable at the end of July. Group of answer choices $79,200 $61,920 $10,080 $40,320
Management is planning to increase menu prices 4 percent and also expects a 3 percent increase in sales volume. Forecast food sales for months 1-3 by using the following historical information: Month Sales Volume Last Year Month 1 $140,000 Month 2 175,000 Month 3 190,000
Restaurant Sales Summary for month of February, 2018. Item Prime Rib Fish n Chips Barbecued Duck Total sold 690 560 350 425 280 Cheese Burger Baked Lasagna Total a. Number of Covers sold per day_ PPOP % S.P. $19.00 $14.00 $11.00 $10.00 $11.00 Revenue b. Cost of average covers - $_ c. Total Revenue in the Restaurant in the month of February 2018 d. Restaurant has 50 seats, what is the restaurant turnover ratio?
Sales Forecast using Weighted Moving Average 1. Given the following, determine the expected sales on September 18th and September 19th, using a 3-day weighted moving average. 2. Is your weighted moving average result higher or lower than if you had simply done a 3-day moving average? What caused it to be higher or lower? MONTH DATE ACTUAL SALES IN DOLLARS W1 = 10 W2 = 25 W3 = 30 SEPTEMBER 12 13 14 15 16 17 18 19 $1,500 $2,500 $2.500 $3,500 $3.000 $4,500
Treasure Service anticipates the following sales revenue over a five-month period: Its collection history indicates that credit sales are collected as follows: E (Click the icon to view the sales data.) A (Click the icon to view the collections data.) The company's sales are 20% cash and 80% credit. How much cash will be collected in Janua More Info 25% in the month of the sale 50% in the month after the sale Complete the cash budget to determine how much cash will be collected in January, February, March and for the quarter in total. (Round your answers to the nearest whole do 20% two months after the sale Treasure Service 5% are never collected Cash Collections Budget For the Months of January through March January Data Table Print Done Cash sales Collection of credit sales: 25% Month of sale November December January February March 50% Month after Sales revenue....... 16,100 $ 10,000 $ 15,200 $ 12,000 $ 14,200 20% Two months after Total cash collections Print Done
Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter which has been provided in the below table. Following Year Quarter in Coming Year Second $362 Third $338 Fourth $386 First First Quarter Sales forecast $374 $386 Paymore's labor and administrative expenses are $67 per quarter and interest on long-term debt is $42 per quarter. Paymore's cash balance at the start of the first quarter is $40 and its minimum acceptable cash balance is $30. Assume that Paymore can borrow up to $338 from a line of credit at an interest rate of 2% per quarter. On average, one-third of sales are collected in the quarter that they are sold, and two-thirds are collected in the following quarter. Assume that sales in the last quarter of the previous year were $338. On average, two-thirds of purchases are paid for in the quarter that they are purchased, and one-third are paid in the following quarter. Prepare a short-term financing plan using the above table. (Leave no…
FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements. Type of Box Direct material required per 100 boxes: Paperboard ($0.30 per pound) Corrugating medium ($0.15 per pound). Direct labor required per 100 boxes ($18.00 per hour). Indirect material Indirect labor Utilities Property taxes Insurance Depreciation. Total C $12,150 95,850 31,500 21,000 16,000. 33,500 $210,000 Total 40 pounds 30 pounds 0.25 hour The following production-overhead costs are anticipated for the next year. The predetermined overhead rate is based on a production volume of 400,000 units for each type of box. Production overhead is applied on the basis of direct-labor hours. The following selling and administrative expenses are anticipated for the next year. Salaries and fringe benefits of sales personnel. Advertising $115,500 23,500…
You collect 75% of a month's sales in the month of the sale and 25% of sales in the following month. May sales June sales July sales O $105 O $35 $120 Compute cash inflows for June. $135 $140 $100 not enough information, because sales revenue differs
Wiggles Right forecasted sales of $5,000 in October, $4,000 in November, and $4,000 in December. All sales are on credit. 40% is collected the month of sale, and the remainder the following month. How much is collected from accounts receivable in November? Group of answer choices $6,000 $4,600 $5,400 $4,800
Please Do both questions Delphino’s has sales for the year of $127,300 and cost of goods sold of $86,700. The firm carries an average inventory of $14,300 and has an average accounts payable balance of $13,600. What is the inventory period? 81.36 days 60.20 days 58.68 days 89.02 days The Lumber Yard has projected sales for April through July of $152,400, $161,800, $189,700, and $196,400, respectively. The firm collects 52 percent of its sales in the month of sale, 46 percent in the month following the month of sale, and the remainder in the second month following the month of sale. What is the amount of the July collections? $181,508 $122,852 $189,819 $192,626