Novela, Inc. produces office supplies, including pencils. Pencils are bundled in packages; each package sells for P20. The sales budget for the first four (4) months of the year follows for this product: Rolls in units January 200,000 February 240,000 March 220,000 April 200,000 Company policy requires that ending inventories for each month to be 10% of next month's sales. However, due to greater sales in December than anticipated, the ending inventory of pencils for that month is only 10,000 packages. Required: Prepare a production budget for the first quarter of the year. Show the number of units that should be produced each month and for the quarter in total.

Novela, Inc. produces office supplies, including pencils. Pencils are bundled in packages; each package sells for P20. The sales budget for the first four (4) months of the year follows for this product: Rolls in units January 200,000 February 240,000 March 220,000 April 200,000 Company policy requires that ending inventories for each month to be 10% of next month's sales. However, due to greater sales in December than anticipated, the ending inventory of pencils for that month is only 10,000 packages. Required: Prepare a production budget for the first quarter of the year. Show the number of units that should be produced each month and for the quarter in total.

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

Kent Company has a sales budget for next month of $1,000,000. Cost of goods sold is expected to be 25 percent of sales. All goods are paid for in the month following purchase. The beginning inventory of merchandise is $50,000, and an ending inventory of $64,000 is desired. Beginning accounts payable is $160,000. For Kent Company, the ending accounts payable should be: Select one: O A. $341,000 B. $414,000 C. $264,000 D. $356,000
Kemmerly Company opens in September and plans to purchase wallets for $15 and sell them for $20 per wallet. Kemmerly Company maintains ending inventory of 25% of next months sales. They plan to sell 1,800 units in September, 2,000 in October, and 2,250 in November. What is the budgeted cost of goods sold in November?
Aztec Company sells its product for $150 per unit. Its actual and budgeted sales follow. May (Actual) June (Budget) July (Budget) August (Budget) 6,000 4,100 $ 900,000 2,400 5,000 $360,000 $750,000 $ 615,000 Sales units Sales dollars. All sales are on credit. Collections are as follows: 24% is collected in the month of the sale, and the remaining 76% is collected in the month following the sale. Merchandise purchases cost $110 per unit. For those purchases, 60% is paid in the month of purchase and the other 40% is paid in the month following purchase. The company has a policy to maintain an ending monthly inventory of 22% of the next month's unit sales. The May 31 actual inventory level of 1,320 units is consistent with this policy. Selling and administrative expenses of $114,000 per month are paid in cash. The company's minimum cash balance at month-end is $140,000. Loans are obtained at the end of any month when the preliminary cash balance is below $140,000. Any preliminary cash…
Yummy Foods expects to have 43,000 pounds of raw materials inventory on hand on March 31, the end of the current year. The company budgets the following production (in units) for April through July, inclusive: April 127,000 May 137,000 June 153,000 July 127,000 At the end of each month the firm desires its ending raw material inventory to be 10% of the next month's production needs. Each finished unit requires three pounds of raw materials.Yummy Foods’ budgeted purchases for raw materials (in pounds) during April should be:
Shamrock Shades purchases sunglasses from bulk discounters and sells the sunglasses in mall kiosks throughout the Pacific Northwest. Shamrock is in the process of budgeting for the coming year and has projected sales of $360,000 for January, $440,000 for February, $600,000 for March, and $640,000 for April. Shamrock's desired ending inventory is 55 percent of the following month's cost of goods sold. Cost of goods sold is expected to be 45 percent of sales. Required: Compute the required purchases for each month of the first quarter (January through March). January Required Purchases February March
Sports Socks has a policy of always paying within the discount period and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 85% of its payments are made in the month of purchase and 15% are made the following month. The direct materials budget provides for purchases of $125,000 in November, $298,000 in December, $236,000 in January, and $232,000 in February. What is the balance in accounts payable for January 31, and February 28? Ending Balance January $fill in the blank 1 February fill in the blank 2
Shakira Inc. sells drones. The company is in the process of preparing its Selling and Administrative Expense Budget for the year. The following budget data are available: Variable Cost Per Drone Sold Monthly Fixed Cost Sales commissions $0.40 $ 12,000 Shipping 3.20 Advertising 0.25 Executive salaries 60,000 Depreciation on office equipment 4,000 Expenses are paid in the month incurred. If the company has budgeted to sell 20,000 drones in July, how much is the total budgeted selling and administrative expenses for July?
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…
Blue Wave Co. predicts the following unit sales for the coming four months: September, 3,300 units; October, 4,900 units; November, 6,700 units; and December, 7,900 units. The company's policy is to maintain finished goods inventory equal to 50% of the next month's sales. At the end of August, the company had 2,800 finished units on hand. Prepare a production budget for each of the months of September, October, and November. Blue Wave Co. Production Budget September, October and November September Next month's budgeted sales (units) Units to be produced % October % November %
COVID19Co produces hand tools. A sales budget for the next four months is as follows March10.700 units, April 13.600, May 16,200, and June 21.200 COVID19Co's ending finished goods inventory policy is 10% of the following month's sales. What is budgeted ending finished goods inventory for March?
Furniture, Inc. makes and sells a single product called a Bik. The company wants to prepare the direct material budget for the quarter ending June 30. Budgeted production of Biks for the next six months is as follows: February 14,000 Units March 15,500 Units April 11,900 Units May 12,600 Units June 14,500 Units July 16,000 Units It takes three yards of Material A to make one Bik. The company wants to maintain monthly ending inventory of Material A equal to 20% of the following month's production needs. On March 31, 2,000 yards of Material A were on hand. The cost of Material A is $5 per yard. Required: 1. Prepare the Direct Materials Budget for April, May, June, and quarter. 2. Based on the direct material budget that you prepared in requirement 1 above and assume that the direct materials purchase in February was $150,000 and in March was $160,000. Prepare the cash disbursements budget for April if the company policy for paying purchases is as follows: 10% in the month of purchase.…