Problem 2Meals Company is a startup company producing and delivering boxed meals to tailgate parties.The company operates four months, September through December, during a fiscal year. Assumethere are zero costs during the ensuing eight months. The company owner has forecasted thefollowing sales and financial data for the upcoming fiscal year:Meal boxes sold20,000 total boxes; the sales forecast for the meals sold by monthfollows:Forecast5,0005,0008,0002,000SeptemberOctoberNovemberMeal box sales priceFood costWagesDecember$5.00$2.00 per boxFood preparerOwner$10 per hour; 0.05 hours per box$20,000 salary$1,000 + $0.10 per box$3.50 per gallon20 miles per gallon400 total miles driven delivering meals$4,000$6,000UtilitiesFuelFacilitiesMiscellaneousRequired(a) Prepare an annual budget for the fiscal yearAnnual Budget $RevenueExpensesTotal ExpensesNOI7 (b) Assume the entire company sales and costs occur during a 4 month fall period. Assumethere are zero costs during the ensuing eight months. The actual ales of meals through theend of November were as follows:Actual4,5005,8009,0002,000SeptemberOctoberNovemberDecember (forecast)Assume the company owner uses a flexible budget to analyze cost. The following resultsfor November were recorded:Actual miles driven: 125 milesThe static budget and actual results for November were as follows:NovemberFlexFlexedBudgetActualBudgetVarianceRevenue$40,000$44,500ExpensesSalaries and Wages$9,000$9,700$17,200Raw Materials$16,000$1,050$18$1,200$30UtilitiesFuel$1,000$1,500$1,000$1,500FacilitiesMiscellaneousTotal Expenses$28,568$30,630NOI$11,433$13,870Required: Compute November's flexible budget and the flexed variance (variancebetween actual and flexed budget). Enter the results into the above table. Showyour calculations below.

Budget: Budget is a systematic estimation of expenses and revenues for a given period. It includes…

Meals Company is a startup company producing and delivering boxed meals to tailgate parties. The company operates four months, September through December, during a fiscal year. Assume there are zero costs during the ensuing eight months. The company owner has forecasted the following sales and financial data for the upcoming fiscal year: Meal boxes sold 20,000 total boxes; the sales forecast for the meals sold by month follows: September October November Forecast 5,000 5,000 8,000 2,000 December $5.00 $2.00 per box Meal box sales price Food cost Wages Food preparer Owner $10 per hour; 0.05 hours per box $20,000 salary $1,000 + $0.10 per box $3.50 per gallon 20 miles per gallon 400 total miles driven delivering meals $4,000 $6,000 Utilities Fuel Facilities Miscellaneous Required (a) Prepare an annual budget for the fiscal year Annual Budget $ Revenue Expenses Total Expenses NOI

Meals Company is a startup company producing and delivering boxed meals to tailgate parties. The company operates four months, September through December, during a fiscal year. Assume there are zero costs during the ensuing eight months. The company owner has forecasted the following sales and financial data for the upcoming fiscal year: Meal boxes sold 20,000 total boxes; the sales forecast for the meals sold by month follows: September October November Forecast 5,000 5,000 8,000 2,000 December $5.00 $2.00 per box Meal box sales price Food cost Wages Food preparer Owner $10 per hour; 0.05 hours per box $20,000 salary $1,000 + $0.10 per box $3.50 per gallon 20 miles per gallon 400 total miles driven delivering meals $4,000 $6,000 Utilities Fuel Facilities Miscellaneous Required (a) Prepare an annual budget for the fiscal year Annual Budget $ Revenue Expenses Total Expenses NOI

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

Bonita & Pharoah Fabricators produces commemorative bricks that organizations use for fundraising projects. David Bonita, the company's vice president of marketing, has prepared the following sales forecast for the first six months of the coming year. The company plans to sell the bricks for $24 each. January February March April May June 25,000 28,000 32,000 34,000 26,000 35,000 Bonita & Hill Fabricators' marketing department has identified the following monthly expenses that will be needed to support the company's sales and administrative functions. Depreciation $12,000 Sales staff salaries $29,000 Advertising $2,200 Executive salaries $36,000 Miscellaneous $1,700 In addition to these monthly expenses, the company will pay a commission to its salespeople equal to 8% of the sales revenue from each brick sold. The company expects bad debt expense to be 2% of sales revenue.Prepare…
Vikrambhai
The Posh Cushion Company manufactures foam cushions. The number of cushions to be produced in the upcoming three months follows: Number of foam cushions to be produced in July Number of foam cushions to be produced in August Number of foam cushions to be produced in September 13,000 15,000 7,000 Each cushion requires 2 pounds of the foam used as stuffing. The company has a policy that the ending inventory of foam each month must be equal to 15% of the following month's expected production needs. How many pounds of foam does The Posh Cushion Company need to purchase in August? OA. 32,100 B. 34,500 OC. 25,500 OD. 27,600
The Constantine Corporation purchases robes for $12 per unit and then sells them for $25 per unit. The company estimated the following sales for the first four months of the current year: January 8,000 units, February 12,000 units, March 9,000 units and April 7,000 units. The company has rent expense of $5,600 and personnel salaries of $32,000 each month as well as variable advertising costs of $3 per unit based on monthly sales. Ending inventory at December 31st is 2,000 units and for each month after that is expected to be 10% of the next month's sales. What is the company's budgeted net income for February?
Trapper Cycles manufactures chainless bicycles. On March 31, Trapper Cycles had 309 bikes in inventory. The company has a policy that the ending inventory in any month must be 30% of the following month's expected sales. Trapper Cycles expects to sell the following number of bikes in each of next four months: (Click the icon to view the data) Prepare a production budget for the second quarter, with a column for each month and for the quarter. Trapper Cycles Production Budget For the Months of April through June April May Unit sales Plus: Desired ending inventory Total needed Less: Beginning inventory Units to produce 1030 Data table April May June July 1160 June 1340 Quarter 1,030 bikes 1,160 bikes. 1,320 bikes. 1,250 bikes 3530 - X
Sandhill Traders is one of the largest RV dealers in Austin, Texas, and sells about 2,800 recreational vehicles a year. The cost of placing an order with Sandhill's supplier is $500, and the inventory carrying costs are $260 for each RV. Management likes to maintain safety stock of 12 RVs. Most of its sales are made in either the spring or the fall. How many orders should the firm place this year? (Round intermediate calculations to 1 decimal place, e.g. 15.5 and final answer to 0 decimal places, e.g. 15.)
Graham Company projects the following sales for the first three months of the year: $10,600 in January: $14,600 in February; and $16,300 in March. The company expects 80% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Read the requirements. Requirement 1. Prepare a schedule of cash receipts for Graham for January, February, and March. What is the balance in Accounts Receivable on March 31? (If an input field is not used, leave the input field empty. Do not enter a zero.) Cash Receipts from Customers Total sales Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credit sales, collection of February sales in…
Office World Inc. has “cash and carry” customers and credit customers. Office World estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 40% pay their accounts in the month of sale, while the remaining 60% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $700,000 November 650,000 December 500,000 The Accounts Receivable balance on September 30 was $290,000. Prepare a schedule of cash collections from sales for October, November, and December. Enter all amounts as positive numbers. Office World Inc.Schedule of Collections from SalesFor the Three Months Ending December 31 October November December Receipts from cash sales: Cash sales $fill in the blank 1 $fill in the blank 2 $fill in the blank 3 September sales on account: Collected in October fill in the blank 4 October sales on…
The Chani Company had the following sales forecast: January February March April 440 500 380 300 The company buys products for $320 each and then resells them for $430 each and pays for operating expenses of $2,100 in rent and $6,300 in salaries each month. The company maintains ending inventory of 20% of next month's sales and had 130 units of inventory at the end of last year. For January, what total dollar amount would appear in the company's purchases budget?
Osage Incorporated has actual sales for May and June and forecast sales for July, August, September, and October as follows: Actual: May June Forecast: July August 5,300 units 7,800 units September 5,900 units October 5,800 units 6,900 units 6,600 units Required: a. The firm's policy is to have finished goods inventory on hand at the end of the month that is equal to 50% of the next month's sales. It is currently estimated that there will be 2,650 units on hand at the end of June. Calculate the number of units to be produced in each of the months of July, August, and September. b. Each unit of finished product requires 8 pounds of raw materials. The firm's policy is to have raw material inventory on hand at the end of each month that is equal to 80% of the next month's estimated usage. It is currently estimated that 25,000 pounds of raw materials will be on hand at the end of June. Calculate the number of pounds of raw materials to be purchased in each of the months of July and August.…
The Company manufactures foam cushions. The number of cushions to be produced in the upcoming three months follows: Number of foam cushions to be produced in July 13,000 Number of foam cushions to be produced in August 19,000 Number of foam cushions to be produced in September 12,000 Each cushion requires 2 pounds of the foam used as stuffing. The Company has a policy that the ending inventory of foam each month must be equal to 30% of the following month's expected production needs. How many pounds of foam does the Company need to purchase in August?
Grace manufactures and sells miniature digital cameras for $250 each. 1,000 units were sold in May, and management forecasts 4% growth in unit sales each month. Determine (a) the number of units of camera sales and (b) the dollar amount of camera sales for the month of June.