It is time for Jung So Min Corp. to begin its annual budget preparation for its...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
It is time for Jung So Min Corp. to begin its annual budget preparation for its upcoming fiscal year, which ends on December 31, 2021. They are in need of temporary assistance in their accounting office and have hired you to carry out the task of preparing the budgets. Jung So Min prepares quarterly budgets, and then from this information prepares an annual budget. To assist you in this task, Jung So Min has gathered the following information: a) Sales for the first quarter of 2021 are expected to be 6,200 units, and sales are expected to grow at a rate of 12% of the previous quarter's sales for all of 2021 and 2022. Selling price is expected to remain constant at $50 per unit. b) Based on past experience, sales are expected to be 30% cash sales, and 70% sales on account. Jung So Min expects that 5% of the sales on account will never be collected, but the other 95% of sales on account will be collected in full in the quarter following the quarter of sale. Accounts receivable are expected to be $180,000 at the start of the first quarter in 2021 and will be collected in full. c) In order to meet expected demand at the beginning of the next quarter, Jung So Min wants ending inventory equal to 22% of the next quarter's budgeted sales. Inventory on hand at the end of 2020 (the start of the first quarter for 2021) is expected to be 1,200 units. d) Jung So Min is a wholesaler and purchases its inventory from the manufacturer at a cost of $36 per unit. This is the cost paid in the last quarter of 2020 and cost is expected to remain constant throughout the next five quarters. e) Jung So Min purchases from the manufacturer on account and has three weeks to pay. Accordingly, Jung So Min expects to pay 70% of its inventory purchases in the quarter of purchase, and the remaining 30% in the quarter following the quarter of purchase. Jung So Min anticipates owing $50,000 to suppliers at the start of the first quarter in 2021. f) Jung So Min incurs selling and administrative costs as follows: i) Jung So Min pays its selling staff fixed salaries plus commission. The fixed salaries total $32,000 per quarter, and the commission is 5% of sales revenue. Salaries and commissions are paid in full in the quarter the costs are incurred. ii) Advertising costs are fixed at $6,500 per quarter and are paid in cash. iii) Office salaries are expected to be $10,000 per quarter, again paid in cash each quarter. iv) Property taxes for 2021 are expected to be $16,000; payment is due in the third quarter and Jung So Min intends to pay the entire year's assessment during that quarter. v) Utilities are expected to be constant at $3,500 per quarter. vi) The annual insurance premium is expected to be $4,500 and will be paid in the first quarter. g) Jung So Min expects to have an opening cash balance of $5,200 at the start of the first quarter of 2021. h) Jung So Min has decided that it must maintain a minimum cash balance of $5,000. It has arranged a line of credit with the bank but must borrow in $1,000 increments. The loan must also be paid in $1,000 increments. Jung So Min's policy is to make payments on the line of credit if there is sufficient cash available, again ensuring the cash balance is not below $5,000. Interest expense is calculated at a rate of 8% per year and is paid as accrued each quarter. It is expected that the line of credit balance advanced and outstanding at the end of 2020 will be S2,000. i) Jung So Min has common shares with a book value of $100,000 outstanding at the end of 2020. It does not intend to issue or repurchase any common shares during the year. The retained earnings is expected to be $156,200 at the end of 2020. Dividends of $15,000 are expected to be declared and paid in the fourth quarter. j) Jung So Min expects to have fixed assets with a net book value of $85,000 at the end of 2020. Equipment purchases are expected to be $38,000 in the first quarter, and $23,000 in the fourth quarter. Depreciation is calculated on a straight-line basis. The expected useful life remaining on the assets on hand at the end of 2020 is 5 years; the new assets are expected to be used for 10 years. Jung So Min begins depreciating new assets in the quarter after they are purchased. k) Jung So Min pays corporate tax at a rate of 25%. No instalments are planned for 2021; the balance owning will be paid in full on filing the 2021 tax return in 2022. Note: Use of a spreadsheet program on the computer is required. Partial units cannot be sold or produced; please round up to the nearest whole unit. Please make sure to use the rounding function in the software and present all numbers as whole numbers. Note that financial statements NEVER present pennies. 50 Required: Prepare the following on a single sheet in Excel: Using a five-column format, with one column for each quarter and then one column for the year: i. Prepare the sales budget. Prepare the inventory purchases budget in units, and then multiply the ii. required inventory purchases by the unit cost to determine the purchases in dollars. i. Prepare the schedule of expected cash collections iv. Prepare the schedule of expected cash disbursements - inventory purchases It is time for Jung So Min Corp. to begin its annual budget preparation for its upcoming fiscal year, which ends on December 31, 2021. They are in need of temporary assistance in their accounting office and have hired you to carry out the task of preparing the budgets. Jung So Min prepares quarterly budgets, and then from this information prepares an annual budget. To assist you in this task, Jung So Min has gathered the following information: a) Sales for the first quarter of 2021 are expected to be 6,200 units, and sales are expected to grow at a rate of 12% of the previous quarter's sales for all of 2021 and 2022. Selling price is expected to remain constant at $50 per unit. b) Based on past experience, sales are expected to be 30% cash sales, and 70% sales on account. Jung So Min expects that 5% of the sales on account will never be collected, but the other 95% of sales on account will be collected in full in the quarter following the quarter of sale. Accounts receivable are expected to be $180,000 at the start of the first quarter in 2021 and will be collected in full. c) In order to meet expected demand at the beginning of the next quarter, Jung So Min wants ending inventory equal to 22% of the next quarter's budgeted sales. Inventory on hand at the end of 2020 (the start of the first quarter for 2021) is expected to be 1,200 units. d) Jung So Min is a wholesaler and purchases its inventory from the manufacturer at a cost of $36 per unit. This is the cost paid in the last quarter of 2020 and cost is expected to remain constant throughout the next five quarters. e) Jung So Min purchases from the manufacturer on account and has three weeks to pay. Accordingly, Jung So Min expects to pay 70% of its inventory purchases in the quarter of purchase, and the remaining 30% in the quarter following the quarter of purchase. Jung So Min anticipates owing $50,000 to suppliers at the start of the first quarter in 2021. f) Jung So Min incurs selling and administrative costs as follows: i) Jung So Min pays its selling staff fixed salaries plus commission. The fixed salaries total $32,000 per quarter, and the commission is 5% of sales revenue. Salaries and commissions are paid in full in the quarter the costs are incurred. ii) Advertising costs are fixed at $6,500 per quarter and are paid in cash. iii) Office salaries are expected to be $10,000 per quarter, again paid in cash each quarter. iv) Property taxes for 2021 are expected to be $16,000; payment is due in the third quarter and Jung So Min intends to pay the entire year's assessment during that quarter. v) Utilities are expected to be constant at $3,500 per quarter. vi) The annual insurance premium is expected to be $4,500 and will be paid in the first quarter. g) Jung So Min expects to have an opening cash balance of $5,200 at the start of the first quarter of 2021. h) Jung So Min has decided that it must maintain a minimum cash balance of $5,000. It has arranged a line of credit with the bank but must borrow in $1,000 increments. The loan must also be paid in $1,000 increments. Jung So Min's policy is to make payments on the line of credit if there is sufficient cash available, again ensuring the cash balance is not below $5,000. Interest expense is calculated at a rate of 8% per year and is paid as accrued each quarter. It is expected that the line of credit balance advanced and outstanding at the end of 2020 will be S2,000. i) Jung So Min has common shares with a book value of $100,000 outstanding at the end of 2020. It does not intend to issue or repurchase any common shares during the year. The retained earnings is expected to be $156,200 at the end of 2020. Dividends of $15,000 are expected to be declared and paid in the fourth quarter. j) Jung So Min expects to have fixed assets with a net book value of $85,000 at the end of 2020. Equipment purchases are expected to be $38,000 in the first quarter, and $23,000 in the fourth quarter. Depreciation is calculated on a straight-line basis. The expected useful life remaining on the assets on hand at the end of 2020 is 5 years; the new assets are expected to be used for 10 years. Jung So Min begins depreciating new assets in the quarter after they are purchased. k) Jung So Min pays corporate tax at a rate of 25%. No instalments are planned for 2021; the balance owning will be paid in full on filing the 2021 tax return in 2022. Note: Use of a spreadsheet program on the computer is required. Partial units cannot be sold or produced; please round up to the nearest whole unit. Please make sure to use the rounding function in the software and present all numbers as whole numbers. Note that financial statements NEVER present pennies. 50 Required: Prepare the following on a single sheet in Excel: Using a five-column format, with one column for each quarter and then one column for the year: i. Prepare the sales budget. Prepare the inventory purchases budget in units, and then multiply the ii. required inventory purchases by the unit cost to determine the purchases in dollars. i. Prepare the schedule of expected cash collections iv. Prepare the schedule of expected cash disbursements - inventory purchases
Expert Answer:
Answer rating: 100% (QA)
a Calculation of Sales Budget Particulars Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Year Expecte... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
At 1.4 mg/mL pure tubulin, microtubules grow at a rate of about 2 m/min. At this growth rate, how many -tubulin dimers (8 nm in length) are added to the ends of a microtubule each second?
-
A kayak moves at a rate of 12 mph in still water. If the river's current flows at a rate of 4 mph, how long does it take the boat to travel 36 mi upstream?
-
It is time for true confessions. Describe three instances when your purchase behavior was inconsistent with an attitude toward the product or service you were buying. Explain why this happened. Share...
-
Consider the agency relationship in malpractice cases under a contingency fee system. The plaintiff (party that sues) typically pays his or her attorney about one-third of any monetary damages that...
-
Which combinations (pounds of each) use all of Crusoe's available 5 hours a day: (i) 11 fish and 0 fruit, (ii) 10 fish and 7 fruit, (iii) 4 fish and 20 fruit?
-
A human generation is about 30 years, and the age of the universe is \(10^{17} \mathrm{~s}\). How many human generations have there been since the beginning of the universe? (Ignore the fact that...
-
Estimate the energy required for an average person (see Fig. 9.32) to run a mile in 4 minutes in still standard air. Compare your estimate if you instead modeled the person as a cylinder \(6...
-
Record the following transactions on the books of Cohen Co. (Omit cost of goods sold entries.) (a) On July 1, Cohen Co. sold merchandise on account to Tracy Inc. for $23,000, terms 2/10, n/30. (b) On...
-
The following information is available for a custom manufacturer. Inventories Raw materials, beginning Work in process, beginning $ 38,100 12,500 Finished goods, beginning 8,850 Cost of goods...
-
When developing a marketing strategy using new digital media, a marketer must be aware of the strengths and weaknesses of these new media. Digital media are relatively new to the field of marketing...
-
Design a 8x1 MUX using 2x1 MUXs.
-
What are the key items to consider when arranging transportation for an athletic team?
-
What are the registration requirements imposed on architects?
-
Consider the duty to inspect; is it realistic that all facilities will be fully inspected prior to each use? How do you balance feasibility with best practice recommendations?
-
To confront the reality of organizational change, one of the most fundamental steps involves recognizing the barriers to change. Then, once these impediments have been identified, consideration can...
-
Critically assess the role of brands for services organizations, using examples from a service sector of your choice.
-
L In triangle ABC, if a = 12cm b = 9cm , and ZA = 60 , find using the Law of Sines. LB
-
Express mass density in kg/m3 and weight density in lb/ft3. 1. Find the mass density of a chunk of rock of mass 215 g that displaces a volume of 75.0 cm3 of water. 2. A block of wood is 55.9 in. x...
-
Before the merger of Mendys and Arbys Wendys made a huge purchase of its own shares and in total bought back over 26 million shares for approximately $1 billion. Before the purchase, 125.5 million...
-
Burke Copy Center purchased a machine on January 1, 2006, for $180,000 and estimated its useful life and salvage value at ten years and $30,000, respectively. On January 1, 2011, the company added...
-
The balance sheet of Natathon International is as follows: Although the balance sheet appears reasonably healthy, Natathon is on the verge of ceasing operations. Appraisers have estimated that, while...
-
Active-Ingredients is a company supplying baking ingredients in major hypermarkets that are facing intense competition from many local and foreign brands. Active-Ingredients is thinking of using a...
-
Nan-Clean is a newly developed cleaning liquid for milk bottles that uses special enzymes to remove dirt effectively. Nan-Clean has been positioned as a product that is made of natural ingredients...
-
Why do sample surveys have predetermined margins of error?
Study smarter with the SolutionInn App