Please do not give solution in image format thanku 41-b. Prepare the schedule of expected cash collections.Accounts receivable, beginning balance1st Quarter sales2nd Quarter sales3rd Quarter sales4th Quarter salesTotal cash collectionsBudgeted unt salesTotal units needed.FORTIN LIMITEDSchedule of Expected Cash CollectionsFirstQuarterRequired production$165,0002. Prepare the company's production budget for the upcoming fiscal yearFirstQuarter165,000 $0SecondQuarterFORTIN LIMITEDProduction Budget0SecondQuarter0050ThirdQuarterThirdQuarter000 $FourthQuarterFourthQuarter00S 165,0000000$YearYear165,0000010 4Fortin Limited produces and sells a single product, a wearable LED light for runners and cyclists. The analytics group at Fortin Limitedhas developed the following estimates for unit sales in the upcoming yearBudgeted init salesFirstQuarter25,600The light sells for $60 per unit and all sales are on account. 75% of sales are expected to be collected in the quarter of sale, with theremainder in the following quarter Accounts receivable at the beginning of the quarter were $165,000 and will all be collected duringthe first quarter of the year.Required:1-8. Prepare the company's sales budget.Budgeted unit salesSeling price per unitTotal SalesAt the end of the previous quarter there were 2.200 units in finished goods inventory. The desired ending finished goods inventory atthe end of each quarter is 10% of the next quarter's budgeted sales. Management expects sales in the fourth quarter of the upcomingyear to be the same as the first quarter of the following year$Second ThirdQuarter Quarter22,200 20,300FirstQuarterFourthQuarter21,600SecondQuarterThirdQuarterFourthQuarterYear

The budgets are prepared to estimate the production requirements for the period. The sales revenue…

4 Fortin Limited produces and sells a single product, a wearable LED light for runners and cyclists. The analytics group at Fortin Limited has developed the following estimates for unit sales in the upcoming year Budgeted unit sales First Quarter The light sells for $60 per unit and all sales are on account. 75% of sales are expected to be collected in the quarter of sale, with the remainder in the following quarter Accounts receivable at the beginning of the quarter were $165,000 and will all be collected during the first quarter of the year Required: 1-a. Prepare the company's sales budget. Budgeted unit sales Seting price per un Total Sales Second Quarter 22,200 At the end of the previous quarter there were 2.200 units in finished goods inventory. The desired ending finished goods inventory at the end of each quarter is 10% of the next quarter's budgeted sales Management expects sales in the fourth quarter of the upcoming year to be the same as the first quarter of the following year First Quarter Third Fourth Quarter Quarter 20,300 21,600 Second Quarter Third Quarter $ Fourth Quarter Year

4 Fortin Limited produces and sells a single product, a wearable LED light for runners and cyclists. The analytics group at Fortin Limited has developed the following estimates for unit sales in the upcoming year Budgeted unit sales First Quarter The light sells for $60 per unit and all sales are on account. 75% of sales are expected to be collected in the quarter of sale, with the remainder in the following quarter Accounts receivable at the beginning of the quarter were $165,000 and will all be collected during the first quarter of the year Required: 1-a. Prepare the company's sales budget. Budgeted unit sales Seting price per un Total Sales Second Quarter 22,200 At the end of the previous quarter there were 2.200 units in finished goods inventory. The desired ending finished goods inventory at the end of each quarter is 10% of the next quarter's budgeted sales Management expects sales in the fourth quarter of the upcoming year to be the same as the first quarter of the following year First Quarter Third Fourth Quarter Quarter 20,300 21,600 Second Quarter Third Quarter $ Fourth Quarter Year

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter16: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 39P

See similar textbooks

Similar questions

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.
Grace manufactures and sells miniature digital cameras for $260 each. 1,600 units were sold in May, and management forecasts 3% growth in unit sales each month.(a) Determine the number of units of camera sales for the month of June.(b) Determine the dollar amount of camera sales for the month of June.
Osborne Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows: The data from the table are as follows: # of planters to be sold January: 3,400 February: 3,800 March: 3,300 April: 4,900 May: 4,600. Inventory at the start of the year was 850 planters. The desired inventory of planters at the end of each month in the upcoming year should be equal to 25% of the following month’s budgeted sales. Each planter requires three pounds of polypropylene (a type of plastic). The company wants to have 20% of the polypropylene required for next month’s production on hand at the end of each month. The polypropylene costs $0.20 per pound. Requirements Prepare a production budget for each month in the first quarter of the year,…
Use the following (very simplified) numbers in creating your pro-forma income statement: Sales start at $1000 for January and increase by 10% per month (so, February sales will be $1100, March sales will be $1210, etc.). The venture uses a markup of 100%, so the cost of goods is 50% of the sales amount (so, January cost of goods is $500, February cost of goods is $550, etc.). The venture pays a salary of $500/month for the first 6 months, then hires an additional employee in July and pays $1000/month for the rest of the year. The venture pays a total overhead cost (including rent, utilities, and insurance) of $50/month. Payroll taxes start out at $20/month for January-June, then increase to $40/month for July-December. The venture's assets depreciate by $10/month. Office expenses are $15/month for January-April, increase to $25/month for May-August, and go back down to $15/month for September-December
Grace manufactures and sells miniature digital cameras for $330 each. 2,100 units were sold in May, and management forecasts 3% growth in unit sales each month.(a) Determine the number of units of camera sales for the month of June.(b) Determine the dollar amount of camera sales for the month of June.
The Norton Company produces a product that has the following sales expectations for 2007: Month Sales ($) May 150,000 June 150,000 July 300,000 August 450,000 September 600,000 October 300,000 November 300,000 December 75,000 January 150,000 February 170,000 March 180,000 Of these sales, 5% are collected during the month, 70% are collected the next month, and 25% are collected in the third month.The company is in the process of developing the cash budget for July through December. The company has the following monthly expenses: Administrative cost $50,000Lease Payment $10,000 The wage rate for labor is $7.50 per hour, and salespeople receive a commission of 8% of sales. It has been determined that each dollar of sales requires 2 minutes of labor. This labor is done for 10% of the sales three months away, for 80% of the sales two months away, and for 10% of sales one month away, and no labor is spent on the…
A store sells a product that has the annual demand of 16,156 units. It purchases the product from supplier A for $74.4 per unit. The unit inventory carrying cost per year is 14 percent of the unit purchase cost. The cost to place and process an order from the supplier is $107 per order. Supplier A has a delivery lead time of 7 days. The store operates 300 days a year. Assume EOQ model is appropriate. What is the optimal total annual inventory and purchase cost for the store? Use at least 4 decimal places.
please explain how you got your figures
The sales teams has to generate $545,609 in revenue this month for Product X. Its sales price is $314.6 each and is subject to the current sales campaign that gives all customers a 9.1% discount. How many units must be sold to meet that sales target? (your answer must be in whole units)
Vandenberg Inc., produces and sells two products; a celling fan and a table fan.Vandenberg plans to sell 30,000 ceiling fans and 70,000 table fans in the coming year.Product price and cost information includes; Common fixed selling and ad,inistrative expenses total $85,000. Required: 1. What is the sales mix estimated for the next year (calculated to the lowest whole number for each product)? 2. Using the sales mix from Requirement 1, form a package of ceiling fans and table fans.How many ceiling fans and table fans are sold at break-even? 3. Prepare a contribution-margin based income statement for Vandenberg,Inc.,based on the unit sales calculated in Requirement 2. 4. What if Vandenberg,Inc.,wanted to earn operating income equal to $14,000? calculate the number of ceiling fans and table fans that must be sold to earn this level of operating income.(hint;Remeber to form a package of ceiling fans and table fans based on the sales mix and to first calculate the number of packages to…
Mazon Inc. plans to sell 7,000 units each quarter next year. During the first two quarters each unit will sell for OMR12; during the last two quarters the sales price will increase OMR1.50 per unit. What is Mazon's estimated sales revenue for next year? Select one: a. OMR 397,000 b. OMR 357,000 c. OMR 378,000 d. OMR 336,000
This isn't a graded question. Please answer the two following questions asap