Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): 36,000 October 26,000 82,000 November 12,500 September 51,000 December 13,000 July August The selling price of the beach umbrellas is $15 per unit. b. All sales are on account. Based on past experience, sales are collected in the following pattern: 30% in the month of sale 65% in the month following sale. 5% uncollectible Sales for June totaled $465,000. c. The company maintains finished goods inventories equal to 15% of the following month's sales. This requirement will be met at the end of June. d. Each beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires that the ending inventory of Gilden be equal to 50% of the following month's production needs. The inventory of Gilden on hand at the beginning and end of the quarter will be:

Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): 36,000 October 26,000 82,000 November 12,500 September 51,000 December 13,000 July August The selling price of the beach umbrellas is $15 per unit. b. All sales are on account. Based on past experience, sales are collected in the following pattern: 30% in the month of sale 65% in the month following sale. 5% uncollectible Sales for June totaled $465,000. c. The company maintains finished goods inventories equal to 15% of the following month's sales. This requirement will be met at the end of June. d. Each beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires that the ending inventory of Gilden be equal to 50% of the following month's production needs. The inventory of Gilden on hand at the beginning and end of the quarter will be:

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

Sarafiny Corporation is in the process of preparing its annual budget. The following beginning and ending inventory levels are planned for the year. Beginning Inventory Ending Inventory Finished goods (units) 26,000 76,000 Raw material (grams) 56,000 46,000 Each unit of finished goods requires 2 grams of raw material. The company plans to sell 730,000 units during the year. The number of units the company would have to manufacture during the year would be: 730,000 units 806,000 units 674,000 units 780,000 units
Empire Records Incorporated is a music retail store that began operations on January 1, Year 1. The company has budgeted sales as indicated in the following table. The company expects a 5 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. The company expects 50% of the sales on account to be collected in the month of sale with the remaining 50% collected in the month following the sale. Required: a. Complete the sales budget by filling in the missing amounts. b. What are the expected total cash receipts for the month of February? Complete this question by entering your answers in the tabs below. Required A Required B Complete the sales budget by filling in the missing amounts. January February March Sales Budget Cash sales Sales on account Total budgeted sales $ 63,200 140,000 203,200 0 0 Required B >
Garden Sales, Incorporated, sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expense Administrative expense* Total selling and administrative expenses Net operating income *Includes $17,000 of depreciation each month. April $ 550,000 385,000 165,000 75,000 42,500 117,500 $ 47,500 May $ 750,000 525,000 225.000 95,000 56,800 151,800 $ 73,200 June $ 450,000 315,000 135,000 56,000 35,000 91,000 $ 44,000 July $ 350,000 245,000 105,000 35,000 33,000 68,000 $ 37,000 b. Sales are 20% for cash and 80% on account. c. Sales on account are collected over a three-month period with…
Beauty Spa & Co. manufactures a specialised luxury spa that is supplied to five-star hotels around the country. The owner provides you with the following information to prepare its 1st quarter budget: July, August, and September. Budgeted sales are as follows: Month Sales ($) Units Sold May 25,000 250 June 28,000 280 July 30,000 300 August 40,000 400 September 35,000 350 October 37,000 370 Additional information: i) Purchases are budgeted at $5.00 per unit and are paid for in full in the month after purchase. ii) Closing inventory must equal 50% of the next month’s sales. iii) Sales (which are all on credit) are collected as follows: 60% in the month of sale; 30% in the month after the sale; 5% in the second month after the sale. iv) The balance in the bank account as of 30 June is $10,000. Required (show your workings for each question): Prepare the schedule of expected cash collections from…
[The following information applies to the questions displayed below. Morganton Company makes one product and it provided the following information to help prepare the master budget: a. The budgeted selling price per unit is $65. Budgeted unit sales for June, July, August, and September are 8,400, 15,000, 17,000, and 18,000 units, respectively. All sales are on credit. b. Thirty percent of credit sales are collected in the month of the sale and 70% in the following month. c. The ending finished goods inventory equals 30% of the following month's unit sales. d. The ending raw materials inventory equals 20% of the following month's raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. The raw materials cost $2.50 per pound. e. Thirty percent of raw materials purchases are paid for in the month of purchase and 70% in the following month. f. The direct labor wage rate is $12 per hour. Each unit of finished goods requires two direct labor-hours. g.…
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?
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation:a. The Marketing Department has estimated sales as follows for the remainder of the year (in units):05JulyAugustSeptember31,500 October73,000November42,000 December21,5008,0008,500The selling price of the beach umbrellas Is $12 per unit.b. All sales are on account. Based on past experience, sales are collected in the following pattern:30% in the month of sale65% in the month following sale5% uncollectibleSales for June totaled $264,000The company maintains finished goods inventories equal to 15% of the following month's sales. This requirement will be met at the end of JuneEach beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires that the ending inventory of Gilden be equal to 50% of the following month's production needs. The inventory…
You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 100 units February, 95 units March, 102 units April, 107 units May, 114 units June, 122 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 90 units March, 102 units April, 102 units May, 104 units June, 117 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 97 units April, 102 units May, 99 units June, 117 units In March of the current year, sales for the months April through June were reforecasted as follows: April, 102 units May, 94 units June, 107 units In April of the current year, sales for the months May and June were reforecasted as follows: May, 84 units June, 102 units In May of the current year, sales for June were…
Perez Company, which expects to start operations on January 1, 2018, will sell digital cameras in shopping malls. Perez has budgeted sales as indicated in the following table. The company expects a 12 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. Required a. Complete the sales budget by filling in the missing amounts. b. Determine the amount of sales revenue Perez will report on its first quarter pro forma income statement. Complete this question by entering your answers in the tabs below. Required A Required B Complete the sales budget by filling in the missing amounts. (Round intermediate calculations and final answers to 2 decimal places.) Sales January February March $ 46,000 116,000 Cash sales Sales on account Total budgeted sales $ 162,000
Magnolia Interior décor Industries manufactures wooden dining chairs. The selling price of the wooden dining chairs is $15 per unit. The company is preparing detailed budgets for the third quarter (Third quarter includes July, August and September) and fourth quarter (Fourth quarter includes October, November and December) and has assembled the following information to assist in the budget preparation (see below tables). Sales for June totaled $2,000. The company maintains finished goods inventories equal to 15% of the following month's sales. This requirement will be met at the end of June. Calculate the estimated quantity of wooden dining chairs that need to be produced in July. Estimated unit sales for the next several month Month Units July 100 August 200 September 300 October 200 November 200 300 December All sales are on account (i.e., on credit). These sales on account are usually collected in the following pattern: 65% in the month following sale 5% X 130 Correct Answer: 115…
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 35,500 October 25,500 August 81,000 November 12,000 September 50,000 December 12,500 The selling price of the beach umbrellas is $14 per unit. All sales are on account. Based on past experience, sales are collected in the following pattern: 30% in the month of sale 65% in the month following sale 5% uncollectible Sales for June totaled $420,000. The company maintains finished goods inventories equal to 15% of the following month’s sales. This requirement will be met at the end of June. Each beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires that the ending inventory…
Annie’s Homemade Ice Cream is preparing a planning budget for August. Its budgeted revenue per serving is $5.00. It has identified two cost drivers—number of servings and number of labor-hours. The company expects to sell 10,800 servings and to staff 700 employee labor-hours in August. Data concerning the company’s cost formulas are shown below: Fixed Cost Per MonthCost per ServingCost per Labor-HourIngredients expense $ 1.25 Salaries and wages expense$ 7,000 $ 8.00Franchise fee $ 0.25 Credit card processing fees $ 0.09 Utilities expense$ 300$ 0.02 Rent expense$ 3,000 Equipment depreciation expense$ 1,750 Other expenses$ 4,200 In August, the company actually sold 11,200 servings of ice cream and staffed 780 employee labor-hours. It’s budgeted