Data Trevor Cycles manufactures chainless bicycles. On March 31, Trevor Cycles had 206 bikes in inventory. The company has a policy that the ending inventory in any month must be 20% of the following month's expected sales. Trevor Cycles expects to sell the following number of bikes in each of next four months: View the data. Prepare a production budget for the second quarter, with a column for each month and for the quarter. Trevor Cycles Production Budget For the Months of April through June April May June Quarter April.. 1,030 bikes 1030 May June. 1,170 bikes les 1170 1390 1270 206 234 278 254 1,390 bikes esired ending inventory July. 1,270 bikes eeded 1236 1404 1668 4308 206 206 234 646 Beginning inventory 1030 1198 1434 3662 produce Print Done

Data Trevor Cycles manufactures chainless bicycles. On March 31, Trevor Cycles had 206 bikes in inventory. The company has a policy that the ending inventory in any month must be 20% of the following month's expected sales. Trevor Cycles expects to sell the following number of bikes in each of next four months: View the data. Prepare a production budget for the second quarter, with a column for each month and for the quarter. Trevor Cycles Production Budget For the Months of April through June April May June Quarter April.. 1,030 bikes 1030 May June. 1,170 bikes les 1170 1390 1270 206 234 278 254 1,390 bikes esired ending inventory July. 1,270 bikes eeded 1236 1404 1668 4308 206 206 234 646 Beginning inventory 1030 1198 1434 3662 produce Print Done

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

Metro, Incorporated sells backpacks. The Company's accountant is preparing the purchases budget for the first quarter operations. Metro maintains ending inventory at 15% of the following month's expected cost of goods sold. Expected cost of goods sold for April is $78,000. All purchases are made on account with 30% of accounts paid in the month of purchase and the remaining 70% paid in the month following the month of purchase. Sales January $ 44,000 February $ 58,000 Budgeted cost of goods sold Plus: Desired ending inventory Inventory needed Less: Beginning inventory March $ 64,000 8,700 52,700 (6,600) Required purchases $ 43,900 Based on this information the amount of accounts payable appearing on the March 31 pro forma balance sheet is Multiple Choice $19,830. $46,270. $66,100. None of the answers is correct.
Beckett 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: (Click the icon to view additional information.) Inventory at the start of the year was 850 planters. The desired inventory of planters at the end of each month should be equal to 25% of the following month's budgeted sales. Each planter requires four 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.10 per pound. Read the requirements. Data table For the Months of January through March January February March Quarter Number of planters to be sold Units to be produced 3,425 3,400 3,525 10,350 January. 3,400 4 Multiply by: Quantity of direct materials needed per unit Quantity needed for production February 3,500…
Ecology Co. sells a biodegradable product called Dissol and has predicted the following sales for the first four months of the current year: Sales in units O 3,010 O 3,100 O 3,190 O 2,830 O 3,700 Jan. 2,500 Ending inventory for each month should be 15% of the next month's sales, and the December 31 inventory is consistent with that policy. How many units should be purchased in February? Question 8 Feb. 3,100 March. 3,700 April. 2,800 F6 F7 F8
Navigator sells GPS trackers for $60 each. It expects sales of 5,200 units in quarter 1 and a 5% Increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year. Round final answers to nearest whole dollar. Navigator Sales Budget For the Year Ending Dec. 31, 20XX Quarter 1 Quarter 2 Quarter 3 Quarter 4 8 Expected Sales (Units) Sales Price per Unit Total Sales Revenue Total
answer in text form please (without image)
Spacely Sprockets' sales budget shows the following expected total sales: Month January February March April Sales $31,700 $41,700 $36,700 $31,700 The company expects 80% of its sales to be on account (credit sales). Credit sales are collected as follows: 30% In the month of sale and 68% In the month following the sale, with the remainder being uncollectible and written off in the month following the sale. Required: a. Calculate budgeted accounts receivable at the end of each month from February through April. b. Calculate budgeted cash Inflows from collection of receivables for each month from February through April. Note: Round your Intermediate calculations and final answers to the nearest whole dollar amount. a. Budgeted accounts receivable Answer is not complete. b. Budgeted cash inflows from collection of receivables February March April S 17,752 S 23,352 $ 20,552
jeremy inc. produces leather handbags. The production budget for the next four months is:July 5000 units, August 7300, September 7500, October 8800. Eachhandbag requires 0.5 square meters of leather. Jeremy inc's leather inventory policy is 30 percent of next month's production needs. If the leather policy is met, what will the july 1 inventory be?750.0 square meters1095.0 square meters1825.0 square meters300.0 square meters
Please help me with show all calculation thanku