Question

Question 2

1. Smith Ltd manufactures and sells one product. You are presented with the following information for the preparation of the annual operating budget for the period ending 31 December 2021:

• Estimated sales in units are 50,000 units for Quarter 1, 53,000 units for Quarter 2, 62,000 units for Quarter 3, and 65,000 units for Quarter 4. The estimated per unit selling price is $9 for Quarters 1-3, and $10 for Quarter 4.
• Smith Ltd has set the desired ending inventory of its product at 5% of the next quarter’s sales units. In quarter 4 of 2021 continuing into 2022, Smith Ltd aims to decrease this percentage to 2.5% of sales. It is expected that Smith Ltd will sell 60,000 units in Quarter 1 of 2022 and 65,000 units in Quarter 2 of 2022. The beginning inventory on 1 January 2021 is 3,000 units.
• Smith Ltd uses 2.5 kg of direct material per unit to produce its product. Smith Ltd has set the desired ending inventory of its direct material at 15% of the next quarter’s manufacturing needs. The beginning inventory on 1 January 2021 is 17,750 kg of direct material. Smith Ltd has secured a contract price with a supplier, in which the supplier will provide direct materials at a cost of $0.55 per kg over the next 18 months.

Tasks

Prepare the following budgets for the period ending 31 December 2021 (use whole numbers when rounding):

1. Sales budget.
2. Production budget.
3. Direct material purchases budget (use whole numbers when rounding).

2. You are presented with the following information relating to the preparation of Jones Ltd.’s cash budget for the period ending 31 December 2021:

• Budgeted sales are as follows: $800,000 (Quarter 1), $920,000 (Quarter 2), $960,000 (Quarter 3) and, $1,000,000 (Quarter 4). The total sales for Quarter 4 of the previous period were $720,000. 60% of sales are for cash. Collections of credit sales from customers are 75% of credit sales in the quarter of sale and 23% of credit sales in the quarter following the sale. The remaining 2% of credit sales are considered uncollectable and are written off as bad debts at the end of the quarter after the credit sale occurred.
• Jones Ltd has a 30% investment interest in Jemma Ltd. It is expected that Jemma Ltd will declare dividends on 31 March 2021. Dividends declared are paid within 4 weeks after the end of the financial reporting period. Jemma Ltd has a 31 March end-of-financial reporting period. The total estimated dividend to be paid by Jemma Ltd is $450,000. Jones Ltd is entitled to 30% of this dividend.

• Budgeted material purchases are as follows: $140,000 (Quarter 1), $174,000 (Quarter 2), $200,000 (Quarter 3), and $210,000 (Quarter 4). The total material purchases in Quarter 4 of the previous period were $150,000. All material purchases are made on credit. 80% of purchases are paid in the quarter they are purchased in and 20% in the quarter following purchase.
• The following costs/expenses were budgeted for:

	Quarter
	1	2	3	4
Direct labour (hours)	10,000	11,500	12,500	13,000
Marketing expenses ($)	50,000	45,000	40,000	65,000
Administrative expenses ($)	200,000	220,000	220,000	230,000
Income tax payment ($)		300,000

• The cost of direct labour is $20 per hour.
• Manufacturing overhead is applied to products based on direct labour hours. The total budgeted manufacturing overhead cost is $1,175,000 which includes $45,000 per quarter depreciation expenses. Total budgeted labour hours is 47,000 hours.
• Marketing expenses include $5,000 depreciation per quarter and administration expenses include quarterly depreciation of $50,000.
• All expenses and labour costs are paid in the quarter incurred.
• Jones Ltd will pay dividends of $130,000 in Quarter 2.
• To innovate and grow, Jones Ltd is planning to build a new plant shortly. In anticipation of these changes, Jones Ltd purchased equipment at a cost of $130,000. The equipment will be paid for in full in Quarter 2.
• Jones Ltd has a cash balance of $350,000 at the start of Quarter 1 and would like to maintain a minimum end-of-quarter cash balance of $40,000.
• Short-term finance is available in multiples of $10,000 at an 8% per annum interest rate. Borrowings take place at the beginning of the quarter, while all repayments take place at the end of the quarter. Interest payments are made for the amount outstanding at the beginning of the quarter (including new borrowing for the quarter) Repayments are made in multiples of $10,000.

Task

Prepare a cash budget of Jones Ltd for the period ending 31 December 2021. Use whole numbers when rounding.

Answer 1

Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!

Due to character limit I am attaching the image for cash budget and some related workings of Jones Limited.

Smith Ltd.	Year 2021
Ans i- Sales Budget	Qtr. 1	Qtr. 2	Qtr. 3	Qtr. 4	Total	Note
Budgeted unit sales	50,000.00	53,000.00	62,000.00	65,000.00	230,000.00	A
Sell price	9.00	9.00	9.00	10.00		B
Total sales	450,000.00	477,000.00	558,000.00	650,000.00	2,135,000.00	C=A*B

						Year 2022
Ans ii- Production Budget	Qtr. 1	Qtr. 2	Qtr. 3	Qtr. 4	Total	Qtr. 1	Qtr. 2	Note
Budgeted sales (Units)	50,000.00	53,000.00	62,000.00	65,000.00	230,000.00	60,000.00	65,000.00	See A
Add: Desired ending inventory of finished goods	2,650.00	3,100.00	3,250.00	1,500.00	1,500.00	1,625.00		B= 5%, 2.5% of A of next month
Total needed	52,650.00	56,100.00	65,250.00	66,500.00	231,500.00	61,625.00
Less: Beginning inventory of finished goods	3,000.00	2,650.00	3,100.00	3,250.00	3,000.00	1,500.00		C= 5%, 2.5% of A of same month. For quarter 1 its given in the problem.
Production units	49,650.00	53,450.00	62,150.00	63,250.00	228,500.00	60,125.00		D

Ans iii- Material Purchase Budget	Qtr. 1	Qtr. 2	Qtr. 3	Qtr. 4	Total	Qtr. 1	Note
Production units	49,650.00	53,450.00	62,150.00	63,250.00	228,500.00	60,125.00	See D
Material required per unit	2.50	2.50	2.50	2.50	2.50	2.50	E
Material required for production	124,125.00	133,625.00	155,375.00	158,125.00	571,250.00	150,313.00	F=D*E
Add: Closing	20,044.00	23,306.00	23,719.00	22,547.00	22,547.00		G= 15% of F of next month
Total Material required	144,169.00	156,931.00	179,094.00	180,672.00	593,797.00
Less: Opening	17,750.00	20,044.00	23,306.00	23,719.00	17,750.00		H= 15% of F of same month. For quarter 1 its given in the problem.
Material Purchase Budget	126,419.00	136,887.00	155,788.00	156,953.00	576,047.00		I
Cost per kg	0.55	0.55	0.55	0.55	0.55		J
Material Purchase Budget	69,530.00	75,288.00	85,683.00	86,324.00	316,825.00		K=I*J

Jones Ltd.
Schedule of expected cash collections	Qtr. 4- Previous	Qtr. 1	Qtr. 2	Qtr. 3	Qtr. 4	Total
Budgeted Sales Revenue	720,000.00	800,000.00	920,000.00	960,000.00	1,000,000.00	3,680,000.00
Cash Sales- 60%	432,000.00	480,000.00	552,000.00	576,000.00	600,000.00	2,208,000.00
Credit Sales- 40%	288,000.00	320,000.00	368,000.00	384,000.00	400,000.00	1,472,000.00

Collection of accounts Receivable	Qtr. 1	Qtr. 2	Qtr. 3	Qtr. 4	Total
Qtr. 4- Previous	66,240.00	-	-	-	66,240.00
Qtr. 1	240,000.00	73,600.00	0 0 Add a comment Know the answer? Your Answer: Post as a guest Your Name: What's your source? Earn Coins Coins can be redeemed for fabulous gifts. Log In Sign Up Post as anonymous Post Your Answer Not the answer you're looking for? Ask your own homework help question Similar Questions Question Simple Life Food Ltd is a manufacturer of ‘ready to eat meal’ and sells to... Question Simple Life Food Ltd is a manufacturer of ‘ready to eat meal’ and sells to various food outlets for credit and cash basis. The management wants to prepare a master budget for the first ten months of the year ending 31 October 2019, and has compiled the following data: 1. The firm sells a single type of set menu at a price of $24 per set. The sales forecast (in sets) prepared by the marketing department for the ten... Evergreen Corporation is preparing the master budget for the third quarter ending March 31, 2009.  It sells... Evergreen Corporation is preparing the master budget for the third quarter ending March 31, 2009.  It sells a single product for $20 a unit.  Sales are 25% cash and 75% credit.  The credit sales are collected 30% in the month of the sale and the remaining 70% is collected in the next month.  No credit sales occurred in December 2008. The December 31 inventory of finished goods is 15,000 units and projected sales are 20,000, 55000, 65,000, 75,000, and 85,000 units for the first  months... Your company had the following projected unit sales for 2021: 2021 quarter 1: 59,600units 2021 quarter... Your company had the following projected unit sales for 2021: 2021 quarter 1: 59,600units 2021 quarter 2: 21,300 units 2021 quarter 3: 48,300 units 2021 quarter 4: 54,500 units 2022 quarter 1: 43,400 units -each unit produced needs 5 pounds of direct materials. The company had 29000 pounds of direct materials in its ending inventory on decmeber 31, 2019. The company prefers to keep 15000 pounds of direct materals in ending inventory. -the company had 6500 units in its ending... [The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture frames that... [The following information applies to the questions displayed below.] Iguana, Inc., manufactures bamboo picture frames that sell for $20 each. Each frame requires 4 linear feet of bamboo, which costs $2.00 per foot. Each frame takes approximately 30 minutes to build, and the labor rate averages $13 per hour. Iguana has the following inventory policies: Ending finished goods inventory should be 40 percent of next month’s sales. Ending raw materials inventory should be 30 percent of next month’s production. Expected... P13-1 Prepare budgeted income statement and supporting budgets. Cook Farm Supply Company manufactures and sells a... P13-1 Prepare budgeted income statement and supporting budgets. Cook Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available for preparing budgets for Snare for the first 2 quarters of 2017. 1. Sales: quarter 1, 40,000 bags; quarter 2, 56,000 bags. Selling price is $60 per bag. 2. Direct materials: each bag of Snare requires 4 pounds of Gumm at a cost of $3.80 per      pound and 6 pounds of Tarr at $1.50 per... Okay Company is preparing to build its master budget. The budget will detail each quarter’s activity... Okay Company is preparing to build its master budget. The budget will detail each quarter’s activity and the activity for the year in total. The master budget will be based on the following information: a. This will be the first year of operation for Okay Company. b. Budgeted unit sales by quarter for 2019 are projected as follows: First quarter 6,500, Second quarter 6,000, Third quarter 6,100 & Fourth quarter 6,250. First and second quarter 2020 budgeted sales units is... White Corporation’s budget calls for the following sales for next year: Quarter 1 90,000 units Quarter... White Corporation’s budget calls for the following sales for next year: Quarter 1 90,000 units Quarter 3 68,000 units Quarter 2 76,000 units Quarter 4 96,000 units Each unit of the product requires 3 pounds of direct materials. The company’s policy is to begin each quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirements and an inventory of direct materials equal to 20% of that quarter’s estimated direct materials requirements for production. Required: 1.... Data                                    Year 2 Quarter     & Data                                    Year 2 Quarter                              Year 3 Quarter                                            1              2             3    4           1             2 Budgeted unit sales        40,000 60,000 100,000             50,000 70,000 80,000 Selling price per unit $12 Accounts receivable, beginning balance $65,000 Sales collected in the quarter sales are made 75% Sales collected in the quarter after sales are made 25% Desired ending finished goods inventory is 30% of budgeted unit sales of next QTR Finished goods inventory, beginning 12,000 Raw materials required... Galactic Inc. manufactures flying drone toys. Sales units for January, February, March, April and May were... Galactic Inc. manufactures flying drone toys. Sales units for January, February, March, April and May were 700, 680, 752, 712, and 780 respectively. Required: 1. The company’s policy for ending finished goods is 25 percent of next month's sales. Prepare a production budget for the first quarter. 2. The drone toy includes 2 LED lights, which cost $15 each. The company requires ending direct materials to be 20 percent of next month's materials requirement. Prepare a direct materials purchases budget... REQUIREMENTS:   1)    Sales Budget   2)    Production Budget Budgets should be for the individual three (3) months of the... REQUIREMENTS:   1)    Sales Budget   2)    Production Budget Budgets should be for the individual three (3) months of the first quarter of 2019. Include a quarterly total column on the right side. Each budget/requirement should be in a separate tab within one spreadsheet. All pages should be in portrait format using the same font. Use proper rounding and show two (2) decimal places of accuracy on dollar amounts. Round up and show whole amounts on all other figures. (Hint) Excel provides functions for... ADVERTISEMENT Need Online Homework Help? Get Answers For Free Most questions answered within 1 hours. Ask a Question ADVERTISEMENT Active Questions #Python Using a for loop, write a function called farmAnimals() that accepts a list of animals... asked 3 minutes ago Explain the equilibrium position for each of the following: a) Cournot model b) Stackelberg model c)... asked 9 minutes ago Write a MIPS assembly program that asks the user first for a string, then for a... asked 17 minutes ago 20. In a survey of 385 students at Broward College, North Campus, results revealed that 154... asked 17 minutes ago I recently competed in a 5K race that had a mean finish time of µ =... asked 23 minutes ago A researcher is interested in whether the true concentration of nicotine in cigarettes (in milligrams) is... asked 1 hour ago How does the serach space in the context of evolutionary computation relate to the search spaces... asked 1 hour ago Write a version of the selection sort algorithm that can be used to sort a list... asked 1 hour ago Consider the simple five-stage pipeline (Fetch, Decode, Execute, Memory, Write-back) ADD R1, R2, R3 SUB R4,... asked 1 hour ago You work in a materials testing lab and your boss tells you to increase the temperature... asked 1 hour ago Assume all temperatures to be exact, and neglect significant figures for small changes in dimension. A... asked 1 hour ago Write a version of the bubble sort algorithm in a function called bubbleSort that can be... asked 1 hour ago About Contact Terms of Use Privacy Policy Academic Honesty Policy Homework Answer Scanner App Report DMCA © 2022 JustAAA   user contributions licensed under cc by-sa 4.0