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

The Porch 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 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 Porch Cushion Company need to purchase in August? OA. 20,800 OB. 15,400 13,000 11,000 9,000 OC. 27,400 OD. 28,600
(Production schedule) The projected sales, in units,for Einstein Inc. By month for the first four months were January 8,000 February 12,000 March 16,000 April 19,200 Inventory of finished goods on December 31 was 6,400 units. The company desired to have an ending inventory each month equal to one-half of next month's estimated sales. Determine the company's production requirements for each month of the first quarter
Cahuilla Corporation predicts the following sales in units for the coming four months: April May June July Sales in units 240 280 300 240 Each month's ending Finished Goods Inventory should be 40% of the next month's sales. March 31 finished goods inventory is 96 units. A finished unit requires five pounds of direct material B at a cost of $2.00 per pound. The March 31 Raw Materials Inventory has 200 pounds of B. Each month's ending Raw Materials Inventory should be 30% of the following month's production needs. The budgeted production for May is: Select one: a. 288 units. b. 400 units. c. 232 units. d. 280 units. e. 168 units. Clear my choice
Croy Incorporated has the following projected sales for the next five months: Month April May June July August Sales in Units 3,530 3,815 4,530 4,120 3,990 Croy's finished goods inventory policy is to have 50 percent of the next month's sales on hand at the end of each month. Direct materials cost $2.80 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month's production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,673 pounds. Required: 1. Determine budgeted production for April, May, and June. 2. Determine budgeted cost of direct materials purchased for April and May. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Determine budgeted production for April, May, and June. Note: Do not round your intermediate calculations and round your final answers to the nearest whole number. June Budgeted Production (Units) April May
Jackson Inc. produces leather handbags. The production budget for the next four months is: July 5,300 units, August 7,700 units, September 8,400 units, October 8,100 units. Each handbag requires 0.5 square meters of leather. Jackson Inc.’s leather inventory policy is 30% of next month’s production needs. On July 1 leather inventory was expected to be 795 square meters. What will leather purchases be in July? Multiple Choice 2,760 square meters 4,035 square meters 3,010 square meters 3,160 square meters
Silver Company makes a product with peak sales in May of each year. Its sales budget for the second quarter is given below: Budgeted sales (all on account) April $ 320,000 May $520,000 June $ 180,000 Total $ 1,020,000 The company estimates 30% of a month's sales are collected in the month of sale, another 65% are collected in the month following sale, and the remaining 5% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $250,000, and March sales totaled $280,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. Schedule of Expected Cash Collections April February sales March sales $ 12,500 182,000…
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…
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
One Device makes universal remote controls and expects to sell 450 units in January, 750 in February, 450 in March, 600 in April, and 650 in May. The required ending inventory is 20% of the next month’s sales. Prepare a production budget for the first four months of the year. One Device Production Budget For the Four Months Ending April 30, 20XX January February March April Expected Sales fill in the blank 1 fill in the blank 2 fill in the blank 3 fill in the blank 4 fill in the blank 6 fill in the blank 7 fill in the blank 8 fill in the blank 9 Total Required Units fill in the blank 10 fill in the blank 11 fill in the blank 12 fill in the blank 13 fill in the blank 15 fill in the blank 16 fill in the blank 17 fill in the blank 18 Required Production fill in the blank 19 fill in the blank 20 fill in the blank 21 fill in the blank 22 Total fill in the blank 23
Zira Company reports the following production budget for the next four months. Each finished unit requires five pounds of direct materials, and the company wants to end each month with direct materials inventory equal to 20% of next month's production needs, Beginning direct materials inventory for April was 634 pounds. Direct materials cost $6 per pound. Prepare a direct materials budget for April, May, and June. (Round your answers to the nearest whole number.) April May 675 June July Units to produce 634 667 647 ZIRA COMPANY Direct Materials Budget April May June Units to produce Materials needed for production (pounds) Total materials required (pounds) Materials to purchase (pounds) Cost of direct materials purchases
Lexi Company budgets unit sales of 1,510,000 in April, 1,210,000 in May, 320,000 in June, and 1,940,000 in July. Beginning inventory on April 1 is 604,000 units, and the company wants to have 40% of next month's unit sales in inventory at the end of each month. The merchandise cost per unit is $0.50. Prepare a merchandise purchases budget for the months of April, May, and June. LEXI COMPANY Merchandise Purchases Budget April May June Next period budgeted sales units Ratio of inventory to future sales Total required units Units to purchase Cost per unit Cost of merchandise purchases $ $ $
Required information [The following information applies to the questions displayed below.] Shadee Corporation expects to sell 540 sun shades in May and 310 in June. Each shade sells for $156. Shadee's beginning and ending finished goods inventories for May are 65 and 55 shades, respectively. Ending finished goods inventory for June will be 50 shades. Required: 1. Prepare Shadee's sales budget for May and June. 2. Prepare Shadee's production budget for May and June. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required 1equired 2 Prepare Shadee's sales budget for May and June. May June Budgeted Total Sales $ 54,210 x $ 48,360 Required 1 Required 2 >