A. Compute for the sales forecast of a given operation using the following figures:Total transactions per day = 450Transaction distributionBreakfast= 14%AM Snack8%Lunch= 44%PM Snack= 10%Dinner= 24%Number of operating days/month = 30Daily TCAverageCheckMeals ServedBreakfastAM SnackLunchPM SnackDinnerTOTAL=Average checkP 75.0045.00110.0045.00120.00Actual BudgetLast YearNo. of Days inOperation (30)ExpectedAnnual SaleB. Complete the budget worksheet below given some assumptions and figures.EstimatedBudgetAnticipatedChangesNext Year'sBudget

To create a sales forecast budget, we need historical sales data and market trend analysis that…

A. Compute for the sales forecast of a given operation using the following figures: Total transactions per day = 450 Transaction distribution Breakfast AM Snack Lunch PM Snack Dinner = 24% Number of operating days/month = 30 Daily TC Average Check als Served kfast Snack = 14% = 8% = 44% = 10% =h Snack er AL Average check P 75.00 45.00 110.00 45.00 120.00 No. of Days in Operation (30) Expected Annual Sale B. Complete the budget worksheet below given some assumptions and figures.

A. Compute for the sales forecast of a given operation using the following figures: Total transactions per day = 450 Transaction distribution Breakfast AM Snack Lunch PM Snack Dinner = 24% Number of operating days/month = 30 Daily TC Average Check als Served kfast Snack = 14% = 8% = 44% = 10% =h Snack er AL Average check P 75.00 45.00 110.00 45.00 120.00 No. of Days in Operation (30) Expected Annual Sale B. Complete the budget worksheet below given some assumptions and figures.

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

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
Fast pls solve this question correctly in 5 min pls I will give u like for sure Savtk Hanse, Inc., has a cash cycle of 45 days, an operating cycle of 66 days, and an inventory period of 28.5 days. The company reported cost of goods sold in the amount of $345,000, and credit sales were $568,000. What is the company’s average balance in accounts payable and accounts receivable? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)
Bluewater, Inc. has the following estimated quarterly sales for next year. The accounts receivable period is 60 days. What is the expected accounts receivable balance to the nearest dollar at the end of the third quarter? Assume that each month has 30 days. Q2 Q3 Q4 $1,300 $1,425 $2,200 Ⓒa. $800 b. $367 c. $950 d. $733 Qe. $867 Q1 Sales $1,850
You are provided with the following data: inventory - to -sale conversion period = 100days Sale - to - cash conversionperiod = 46 days Purchase - to -payment conversion period30 days What is the operatingcycle?
10
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
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…
Dynamic Futon forecasts the following purchases from suppliers: Jan. Feb. Mar. Apr. May Jun. Value of goods ($ millions) 33 29 26 23 21 21 a. Fifty percent of goods are supplied cash-on-delivery. The remainder are paid with an average delay of one month. If Dynamic Futon starts the year with payables of $23 million, what is the forecasted level of payables for each month? (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place.) b. Suppose that from the start of the year the company stretches payables by paying 50% after one month and 30% after two months. (The remainder continue to be paid cash on delivery.) Recalculate payables for each month assuming that there are no cash penalties for late payment. (Do not round intermediate calculations. Enter your answers in millions rounded to 1 decimal place.)
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
Westmore Products has projected the following quarterly sales. The accounts receivable at the beginning of the year is $425 and the collection period is 45 days What are collections for the first quarter? Sales Q1 $ 700 Multiple Choice $350.00 $658 33 $736 67 $700.00 02 $ 755 Q3 $ 840 Help Save & Exit 04 $ 1,130 Sub
On average, your firm sells $32,300 of items on credit each day. The average inventory period is 27 days and your operating cycle is 47 days. What is the average accounts receivable balance? $872,100 $1.292.000 $904,400 $646,000 $1,518,100
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