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... 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... [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... 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... 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... 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... 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... Cook Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available... 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 pound. 3. Desired inventory levels: Type of Inventory January... ADVERTISEMENT Need Online Homework Help? Get Answers For Free Most questions answered within 1 hours. Ask a Question ADVERTISEMENT Active Questions Which disorder is CORRECTLY paired with an associated neurotransmitter? Question 15 options: a) Parkinson's disease –... asked 18 minutes ago The purpose of this project is to analyze the Ice Storage Systems that companies like Trane... asked 35 minutes ago A proton travels through uniform magnetic and electric fields. The magnetic field is in the negative... asked 54 minutes ago What is the most important feature of a discussion that uses critical thinking? Describe how this... asked 1 hour ago Hi could someone give me a run down of a process to draw free body diagrams?... asked 1 hour ago The National Vaccine Information Center estimates that 89.1% of Americans have had chickenpox by the time... asked 1 hour ago Over the past several months, an adult patient has been treated for tetany (severe muscle spasms).... asked 1 hour ago 1. [1pt] The elastic energy stored in your tendons can contribute up to 35% of your... asked 1 hour ago A bag of 31 tulip bulbs contains 14 red tulip​ bulbs,11 yellow tulip​ bulbs, and 6purple... asked 1 hour ago Engineers must consider the breadths of male heads when designing helmets. The company researchers have determined... asked 1 hour ago Draft a contract not to exceed two pages in length, providing all essential terms, providing for... asked 1 hour ago In the following two problems, the equivalence classes refer to the equivalence classes under the equivalence... asked 2 hours 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