Digital Ltd is a retailer of a popular digital watch and provides you with the following information for the preparation of its 1st quarter budget: July - September. Budgeted sales are as follows: Month Sales ($) Units sold May 250,000 2,500 June 280,000 2,800 July 350,000 3,500 August 400,000 4,000 September 300,000 3,000 October 360,000 3,600 Additional information: i) Purchases are budgeted at $5.00 per unit and are paid for in full in the month after purchase. ii) Ending inventory must equal 40% of of the next month's sales. v) 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. v) The balance in the bank account as at 30 June is $10,000. Required: a) Prepare a purchases budget (in units and $) for the 1st quarter. (Purchases are based on expected sales).

Digital Ltd is a retailer of a popular digital watch and provides you with the following information for the preparation of its 1st quarter budget: July - September. Budgeted sales are as follows: Month Sales ($) Units sold May 250,000 2,500 June 280,000 2,800 July 350,000 3,500 August 400,000 4,000 September 300,000 3,000 October 360,000 3,600 Additional information: i) Purchases are budgeted at $5.00 per unit and are paid for in full in the month after purchase. ii) Ending inventory must equal 40% of of the next month's sales. v) 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. v) The balance in the bank account as at 30 June is $10,000. Required: a) Prepare a purchases budget (in units and $) for the 1st quarter. (Purchases are based on expected sales).

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

i need the answer quickly
I need help solve
You are provided with the following information for Keon Company, You are asked to assist In the budget-setting process. Production budget for January, February and March 2,000 units per month Production budget for April, May and June (and July) 1,800 units per month Production standard-direct material 4.5 kilograms per unit Direct material inventory standard-percentage of closing inventory to next month's production DM required for current month per kilogram 70% Direct material standard cost $25.00 Direct material purchase paid in month of purchase 40% of total purchase amount Direct material purchase paid in following month 60% of total purchase amount Direct material purchases in December 8,000 kilograms Expected 31 December inventory 10,000 kilograms (a) Prepare the direct materials purchase budget in kilograms of material for January to June for Keon Company. Ignore non-round amounts and simply show the nearest whole number for all values.
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): July 30,500 October 20,500 August 71,000 November 7,000 September 40,000 December 7,500 The selling price of the beach umbrellas is $10 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 $200,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%…
Teleco Corp. is preparing its budget for the first quarter of 2018. The following data is provided: Inventory, Purchases, and COGS Budget Jan Feb March Cost of goods sold (a) $30,000 $29,000 $22,500 Desired ending inventory (b) 12,900 12,250 ? Total inventory required 42,900 41,250 Less: Beginning inventory (15,000) (12,900) Budgeted Purchases $27,900 $28,350 (a) COGS = 75% of sales (b) $10,000 + 10% of COGS for next month April's cost of goods sold is $34,000. The amount of Merchandise Inventory to be shown on the budgeted balance sheet at March 31 would be ________.
Use the information below for Flushing Company to answer the question that follow. Below is budgeted production and sales information for Flushing Company for the month of December. Product XXX Product ZZZ Estimated beginning inventory 30,500 units 20,000 units Desired ending inventory 36,500 units 14,900 units Region I, anticipated sales 329,000 units 265,000 units Region II, anticipated sales 190,000 units 148,000 units The unit selling price for product XXX is $5 and for product ZZZ is $13.Budgeted sales for the month are a.$8,812,000 b.$12,116,000 c.$4,660,000 d.$7,964,000
FRANCORP is preparing budgets for the quarter ending March 31. Budgeted sales for the next 5 months are as follows: January February March April May 16250 units 16950 units 17200 units 18350 units 17900 units The selling price per unit is $15. Determine the total budgeted sales for the month of March. O $195.500 O $200,900 $238,550 O $258,000
Subject:- accounting
Atlantic Surf manufactures surfboards. The company's budgeted sales units for the next three months is shown below. Company policy is to maintain finished goods inventory equal (in units) to 40% of the next month's unit sales. As of June 30, the company has 1,760 finished surfboards in inventory. Budgeted sales units July 4,400 August 5,500 September 3,300 Prepare the production budget for the months of July and August. ATLANTIC SURF Production Budget Budgeted sales units Add: Desired ending inventory Desired ending inventory units Total required units Units to be produced July 0 August 0
Please help me with show all calculation thanku
Atlantic Surf manufactures surfboards. The company’s budgeted sales units for the next three months is shown below. Company policy is to maintain finished goods inventory equal (in units) to 50% of the next month’s unit sales. As of June 30, the company has 1,950 finished surfboards in inventory. July August September Budgeted sales units 3,900 7,400 4,500 Prepare the production budget for the months of July and August.
Walker Company prepares monthly budgets. Company policy is to end each month with merchandise inventory equal to 15% of budgeted unit sales for the following month. Budgeted sales and merchandise purchases for the next three months follow. Beginning inventory on July 1 is 27,000 units. The company budgets sales of 200,000 units in October. The merchandise cost per unit is $2. Budgeted sales units. Units to purchase July 180,000 200,250 August 315,000 308,250 September 270,000 259,500 Prepare the merchandise purchases budgets for the months of July, August, and September. WALKER COMPANY Merchandise Purchases Budget July August September Next period budgeted sales units Ratio of inventory to future sales 0 0 0 Total required units Units to purchase Cost per unit Cost of merchandise purchases