Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Note: Please answer question 5, 6. 7, and 8 Note: Please answer question 5, 6. 7, and 8 1. It is time for Jung So

Note: Please answer question 5, 6. 7, and 8

image text in transcribed

image text in transcribed

image text in transcribed

Note: Please answer question 5, 6. 7, and 8

1. 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: 1) 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. 2) 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. 3) 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. 4) 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. 5) 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. 6) 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. 7) Jung So Min expects to have an opening cash balance of $5,200 at the start of the first quarter of 2021. 8) 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 $2,000. 1. 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: 1) 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. 2) 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. 3) 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. 4) 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. 5) 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. 6) 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. 7) Jung So Min expects to have an opening cash balance of $5,200 at the start of the first quarter of 2021. 8) 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 $2,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting What the Numbers Mean

Authors: David H. Marshall, Wayne W. McManus, Daniel F. Viele,

9th Edition

978-0-07-76261, 0-07-762611-7, 9780078025297, 978-0073527062

Students also viewed these Accounting questions