The Penticton Region was so happy with the expertise that you provided to them last year...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Penticton Region was so happy with the expertise that you provided to them last year that they have contacted you to assist them with their budgeting for the upcoming fiscal year. Below is the information that they have provided respecting their sales forecast for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted sales (units) Budgeted sales revenue The region has $19,000 cash on hand at the beginning of the 1st quarter. • A minimum cash balance of $10,000 is required. The region has an open line of credit to support operational needs. All borrowing is done at the beginning of a month, and all repayments are made at the end of a month, borrowings must be in multiples of $1,000. The annual interest rate is 12%. 7,900 $474,000 7,000 $420,000 6,000 $360,000 7,000 $420,000 Interest is paid only at the time of repayment of principal. Accounts receivable at the beginning of the 1" quarter is $32,000 all of which is from sales the previous month. The entire amount will be received in the 1" quarter. Typically, sales are 40% for cash and 60% on credit. Seventy percent (70%) of credit sales are collecting in the quarter that the sale occurs, 30% is collected in the following quarter. The beginning finished goods inventory for the first quarter is expected to be 1,580 units. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,740 units. • The beginning raw materials inventory for the first quarter is budgeted to be 3,520 kilograms. • Each unit requires two kilograms of raw material that costs $8 per kilogram. Management desires to end each quarter with an inventory of raw materials equaling 20% of the following quarter's production needs. The desired ending inventory for the fourth quarter is 3,180 kilograms. Management plans to pay for 65% of raw material purchases in the quarter acquired and 35% in the following quarter. The beginning accounts payable related to raw material purchases of $15,220 will be paid in the first quarter. Dynamadics expects to purchase and pay for new equipment in the 1ª quarter at a price of $25,000. Management has also identified and plans to sell equipment that no longer supports operations in the 2nd quarter for a price of $100,000. There are no depreciation considerations for this equipment. Monthly operating expenses incurred include: o Salaries $12,000 o Due to timing of payroll for the first quarter, 2/3 of the 1“ quarter salary costs will be paid in the first quarter, the remaining 1/3 will paid the next quarter. There is no payable for salaries outstanding at the beginning of the first quarter. o Rent $4,000 o Amortization of pre-paid insurance $1,200 o Depreciation office equipment $1,500 Requirement #2 (24 marks) Prepare the following budgets for the upcoming fiscal year. - production budget - direct material budget - schedule of cash disbursements for direct materials - labour budget - manufacturing overhead budget - cash budget for the 1* and 2nd quarter (round results to the nearest dollar). A template has been created in Excel for your use if desired. However some budget information is missing (coloured cells) be sure to input the missing information in the template. If you feel there is not enough or too many rows for your entries, adjust the template as necessary. The Penticton Region was so happy with the expertise that you provided to them last year that they have contacted you to assist them with their budgeting for the upcoming fiscal year. Below is the information that they have provided respecting their sales forecast for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted sales (units) Budgeted sales revenue The region has $19,000 cash on hand at the beginning of the 1st quarter. • A minimum cash balance of $10,000 is required. The region has an open line of credit to support operational needs. All borrowing is done at the beginning of a month, and all repayments are made at the end of a month, borrowings must be in multiples of $1,000. The annual interest rate is 12%. 7,900 $474,000 7,000 $420,000 6,000 $360,000 7,000 $420,000 Interest is paid only at the time of repayment of principal. Accounts receivable at the beginning of the 1" quarter is $32,000 all of which is from sales the previous month. The entire amount will be received in the 1" quarter. Typically, sales are 40% for cash and 60% on credit. Seventy percent (70%) of credit sales are collecting in the quarter that the sale occurs, 30% is collected in the following quarter. The beginning finished goods inventory for the first quarter is expected to be 1,580 units. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,740 units. • The beginning raw materials inventory for the first quarter is budgeted to be 3,520 kilograms. • Each unit requires two kilograms of raw material that costs $8 per kilogram. Management desires to end each quarter with an inventory of raw materials equaling 20% of the following quarter's production needs. The desired ending inventory for the fourth quarter is 3,180 kilograms. Management plans to pay for 65% of raw material purchases in the quarter acquired and 35% in the following quarter. The beginning accounts payable related to raw material purchases of $15,220 will be paid in the first quarter. Dynamadics expects to purchase and pay for new equipment in the 1ª quarter at a price of $25,000. Management has also identified and plans to sell equipment that no longer supports operations in the 2nd quarter for a price of $100,000. There are no depreciation considerations for this equipment. Monthly operating expenses incurred include: o Salaries $12,000 o Due to timing of payroll for the first quarter, 2/3 of the 1“ quarter salary costs will be paid in the first quarter, the remaining 1/3 will paid the next quarter. There is no payable for salaries outstanding at the beginning of the first quarter. o Rent $4,000 o Amortization of pre-paid insurance $1,200 o Depreciation office equipment $1,500 Requirement #2 (24 marks) Prepare the following budgets for the upcoming fiscal year. - production budget - direct material budget - schedule of cash disbursements for direct materials - labour budget - manufacturing overhead budget - cash budget for the 1* and 2nd quarter (round results to the nearest dollar). A template has been created in Excel for your use if desired. However some budget information is missing (coloured cells) be sure to input the missing information in the template. If you feel there is not enough or too many rows for your entries, adjust the template as necessary. The Penticton Region was so happy with the expertise that you provided to them last year that they have contacted you to assist them with their budgeting for the upcoming fiscal year. Below is the information that they have provided respecting their sales forecast for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted sales (units) Budgeted sales revenue The region has $19,000 cash on hand at the beginning of the 1st quarter. • A minimum cash balance of $10,000 is required. The region has an open line of credit to support operational needs. All borrowing is done at the beginning of a month, and all repayments are made at the end of a month, borrowings must be in multiples of $1,000. The annual interest rate is 12%. 7,900 $474,000 7,000 $420,000 6,000 $360,000 7,000 $420,000 Interest is paid only at the time of repayment of principal. Accounts receivable at the beginning of the 1" quarter is $32,000 all of which is from sales the previous month. The entire amount will be received in the 1" quarter. Typically, sales are 40% for cash and 60% on credit. Seventy percent (70%) of credit sales are collecting in the quarter that the sale occurs, 30% is collected in the following quarter. The beginning finished goods inventory for the first quarter is expected to be 1,580 units. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,740 units. • The beginning raw materials inventory for the first quarter is budgeted to be 3,520 kilograms. • Each unit requires two kilograms of raw material that costs $8 per kilogram. Management desires to end each quarter with an inventory of raw materials equaling 20% of the following quarter's production needs. The desired ending inventory for the fourth quarter is 3,180 kilograms. Management plans to pay for 65% of raw material purchases in the quarter acquired and 35% in the following quarter. The beginning accounts payable related to raw material purchases of $15,220 will be paid in the first quarter. Dynamadics expects to purchase and pay for new equipment in the 1ª quarter at a price of $25,000. Management has also identified and plans to sell equipment that no longer supports operations in the 2nd quarter for a price of $100,000. There are no depreciation considerations for this equipment. Monthly operating expenses incurred include: o Salaries $12,000 o Due to timing of payroll for the first quarter, 2/3 of the 1“ quarter salary costs will be paid in the first quarter, the remaining 1/3 will paid the next quarter. There is no payable for salaries outstanding at the beginning of the first quarter. o Rent $4,000 o Amortization of pre-paid insurance $1,200 o Depreciation office equipment $1,500 Requirement #2 (24 marks) Prepare the following budgets for the upcoming fiscal year. - production budget - direct material budget - schedule of cash disbursements for direct materials - labour budget - manufacturing overhead budget - cash budget for the 1* and 2nd quarter (round results to the nearest dollar). A template has been created in Excel for your use if desired. However some budget information is missing (coloured cells) be sure to input the missing information in the template. If you feel there is not enough or too many rows for your entries, adjust the template as necessary. The Penticton Region was so happy with the expertise that you provided to them last year that they have contacted you to assist them with their budgeting for the upcoming fiscal year. Below is the information that they have provided respecting their sales forecast for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted sales (units) Budgeted sales revenue The region has $19,000 cash on hand at the beginning of the 1st quarter. • A minimum cash balance of $10,000 is required. The region has an open line of credit to support operational needs. All borrowing is done at the beginning of a month, and all repayments are made at the end of a month, borrowings must be in multiples of $1,000. The annual interest rate is 12%. 7,900 $474,000 7,000 $420,000 6,000 $360,000 7,000 $420,000 Interest is paid only at the time of repayment of principal. Accounts receivable at the beginning of the 1" quarter is $32,000 all of which is from sales the previous month. The entire amount will be received in the 1" quarter. Typically, sales are 40% for cash and 60% on credit. Seventy percent (70%) of credit sales are collecting in the quarter that the sale occurs, 30% is collected in the following quarter. The beginning finished goods inventory for the first quarter is expected to be 1,580 units. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,740 units. • The beginning raw materials inventory for the first quarter is budgeted to be 3,520 kilograms. • Each unit requires two kilograms of raw material that costs $8 per kilogram. Management desires to end each quarter with an inventory of raw materials equaling 20% of the following quarter's production needs. The desired ending inventory for the fourth quarter is 3,180 kilograms. Management plans to pay for 65% of raw material purchases in the quarter acquired and 35% in the following quarter. The beginning accounts payable related to raw material purchases of $15,220 will be paid in the first quarter. Dynamadics expects to purchase and pay for new equipment in the 1ª quarter at a price of $25,000. Management has also identified and plans to sell equipment that no longer supports operations in the 2nd quarter for a price of $100,000. There are no depreciation considerations for this equipment. Monthly operating expenses incurred include: o Salaries $12,000 o Due to timing of payroll for the first quarter, 2/3 of the 1“ quarter salary costs will be paid in the first quarter, the remaining 1/3 will paid the next quarter. There is no payable for salaries outstanding at the beginning of the first quarter. o Rent $4,000 o Amortization of pre-paid insurance $1,200 o Depreciation office equipment $1,500 Requirement #2 (24 marks) Prepare the following budgets for the upcoming fiscal year. - production budget - direct material budget - schedule of cash disbursements for direct materials - labour budget - manufacturing overhead budget - cash budget for the 1* and 2nd quarter (round results to the nearest dollar). A template has been created in Excel for your use if desired. However some budget information is missing (coloured cells) be sure to input the missing information in the template. If you feel there is not enough or too many rows for your entries, adjust the template as necessary. The Penticton Region was so happy with the expertise that you provided to them last year that they have contacted you to assist them with their budgeting for the upcoming fiscal year. Below is the information that they have provided respecting their sales forecast for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted sales (units) Budgeted sales revenue The region has $19,000 cash on hand at the beginning of the 1st quarter. • A minimum cash balance of $10,000 is required. The region has an open line of credit to support operational needs. All borrowing is done at the beginning of a month, and all repayments are made at the end of a month, borrowings must be in multiples of $1,000. The annual interest rate is 12%. 7,900 $474,000 7,000 $420,000 6,000 $360,000 7,000 $420,000 Interest is paid only at the time of repayment of principal. Accounts receivable at the beginning of the 1" quarter is $32,000 all of which is from sales the previous month. The entire amount will be received in the 1" quarter. Typically, sales are 40% for cash and 60% on credit. Seventy percent (70%) of credit sales are collecting in the quarter that the sale occurs, 30% is collected in the following quarter. The beginning finished goods inventory for the first quarter is expected to be 1,580 units. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,740 units. • The beginning raw materials inventory for the first quarter is budgeted to be 3,520 kilograms. • Each unit requires two kilograms of raw material that costs $8 per kilogram. Management desires to end each quarter with an inventory of raw materials equaling 20% of the following quarter's production needs. The desired ending inventory for the fourth quarter is 3,180 kilograms. Management plans to pay for 65% of raw material purchases in the quarter acquired and 35% in the following quarter. The beginning accounts payable related to raw material purchases of $15,220 will be paid in the first quarter. Dynamadics expects to purchase and pay for new equipment in the 1ª quarter at a price of $25,000. Management has also identified and plans to sell equipment that no longer supports operations in the 2nd quarter for a price of $100,000. There are no depreciation considerations for this equipment. Monthly operating expenses incurred include: o Salaries $12,000 o Due to timing of payroll for the first quarter, 2/3 of the 1“ quarter salary costs will be paid in the first quarter, the remaining 1/3 will paid the next quarter. There is no payable for salaries outstanding at the beginning of the first quarter. o Rent $4,000 o Amortization of pre-paid insurance $1,200 o Depreciation office equipment $1,500 Requirement #2 (24 marks) Prepare the following budgets for the upcoming fiscal year. - production budget - direct material budget - schedule of cash disbursements for direct materials - labour budget - manufacturing overhead budget - cash budget for the 1* and 2nd quarter (round results to the nearest dollar). A template has been created in Excel for your use if desired. However some budget information is missing (coloured cells) be sure to input the missing information in the template. If you feel there is not enough or too many rows for your entries, adjust the template as necessary. The Penticton Region was so happy with the expertise that you provided to them last year that they have contacted you to assist them with their budgeting for the upcoming fiscal year. Below is the information that they have provided respecting their sales forecast for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted sales (units) Budgeted sales revenue The region has $19,000 cash on hand at the beginning of the 1st quarter. • A minimum cash balance of $10,000 is required. The region has an open line of credit to support operational needs. All borrowing is done at the beginning of a month, and all repayments are made at the end of a month, borrowings must be in multiples of $1,000. The annual interest rate is 12%. 7,900 $474,000 7,000 $420,000 6,000 $360,000 7,000 $420,000 Interest is paid only at the time of repayment of principal. Accounts receivable at the beginning of the 1" quarter is $32,000 all of which is from sales the previous month. The entire amount will be received in the 1" quarter. Typically, sales are 40% for cash and 60% on credit. Seventy percent (70%) of credit sales are collecting in the quarter that the sale occurs, 30% is collected in the following quarter. The beginning finished goods inventory for the first quarter is expected to be 1,580 units. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter's budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,740 units. • The beginning raw materials inventory for the first quarter is budgeted to be 3,520 kilograms. • Each unit requires two kilograms of raw material that costs $8 per kilogram. Management desires to end each quarter with an inventory of raw materials equaling 20% of the following quarter's production needs. The desired ending inventory for the fourth quarter is 3,180 kilograms. Management plans to pay for 65% of raw material purchases in the quarter acquired and 35% in the following quarter. The beginning accounts payable related to raw material purchases of $15,220 will be paid in the first quarter. Dynamadics expects to purchase and pay for new equipment in the 1ª quarter at a price of $25,000. Management has also identified and plans to sell equipment that no longer supports operations in the 2nd quarter for a price of $100,000. There are no depreciation considerations for this equipment. Monthly operating expenses incurred include: o Salaries $12,000 o Due to timing of payroll for the first quarter, 2/3 of the 1“ quarter salary costs will be paid in the first quarter, the remaining 1/3 will paid the next quarter. There is no payable for salaries outstanding at the beginning of the first quarter. o Rent $4,000 o Amortization of pre-paid insurance $1,200 o Depreciation office equipment $1,500 Requirement #2 (24 marks) Prepare the following budgets for the upcoming fiscal year. - production budget - direct material budget - schedule of cash disbursements for direct materials - labour budget - manufacturing overhead budget - cash budget for the 1* and 2nd quarter (round results to the nearest dollar). A template has been created in Excel for your use if desired. However some budget information is missing (coloured cells) be sure to input the missing information in the template. If you feel there is not enough or too many rows for your entries, adjust the template as necessary.
Expert Answer:
Answer rating: 100% (QA)
The Penticton Region Answer 1 Q 1 Q 2 Q 3 Q 4 Yearly Budgeted sales in units 790000 700000 600000 700000 2790000 See A Add Desired Ending Inventory 140000 120000 140000 174000 174000 B20 of A of next ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
At the beginning of an accounting period, a company's revenue, expense, and dividend accounts will always have zero balances. Do you agree or disagree? Explain.
-
At the beginning of a basketball game, a referee tosses the ball straight up with a speed of 4.6 m/s. A player cannot touch the ball until after it reaches its maximum height and begins to fall down....
-
At the beginning of 2014, Kao Company, a small private company, acquired a mine for $850,000. Of this amount, $100,000 was allocated to the land value and the remaining portion to the minerals in the...
-
In Problems 2734, the given pattern continues. Write down the nth term of a sequence {a n } suggested by the pattern. 2 1 1 ,3,-, 5, 7 6 ....: 8
-
Yahoo! Inc.* included these statements in its 2010 annual report: Required a. Compute the following for 2009 and 2010: 1. Net profit margin 2. Total asset turnover (use year- end total assets) 3....
-
The foundational principles of accounting are as follows: Recognition/ Derecognition 1. Economic entity 2. Control 3. Revenue recognition and realization 4. Matching Measurement 5. Periodicity 6....
-
Refer to the data given for the Madison Company in Problem P12-3B. Required a. Compute the change in cash that occurred during 2019. b. Prepare a statement of cash flows using the direct method. Use...
-
Now assume that a court finds that the new rule is merely interpretive. What effect would this determination have on whether the SEC had to follow the APAs rulemaking procedures? Assume that the...
-
The ________ is the time period that elapses from the point when the firm makes the outlay to purchase raw materials on account to the point when payment is made to the supplier of the goods
-
Kalogridis Corp. manufactures industrial dye. The company is preparing its 2011 master budget and has presented you with the following information: a. The projected December 31, 2010, balance sheet...
-
A 120 cm long with diameter of 1 cm is subjected to pull of 20,000 N.If modulus of elasticity(E) = 2 x 10 5 N/mm 2 .Determine: 1.Stress 2.Strain 3.Elongation of rod
-
Define what is meant by tests of transactions. What is the purpose of performing tests of transactions ?
-
Briefly distinguish between direct entry of input data and medium-based entry of input data. Why must auditors understand the different types of methods used to input data into an application system?
-
The concept of materiality is important to the CPA in examination of financial statements and expression of opinion upon these statements. Required : Discuss the following: a. How are materiality...
-
The following is a situation in which information about a population is needed. A large CPA firm has in effect a staff evaluation system by which all assistants are ranked on a scale ranging from 0...
-
Identify general circumstances in which it may be desirable to select sample items with intentional bias.
-
Earnings per share Financial statement data for the years 20Y5 and 20Y6 for Black Bull Inc. follow: Net income Preferred dividends Average number of common shares outstanding 20Y5 20Y6 $1,506,000...
-
Which should drive action planning more, strengths or weaknesses? That is, is it more important to build on your strengths or to reduce your weaknesses? Explain.
-
Kamsack Inc. (Kamsack) was formed in July 2017 to distribute imports from China. During its first year Kamsack had the following equity transactions: i. Issued 100,000 common shares to its two...
-
Would information about each of the following be useful to a prospective long-term creditor of an entity? Would information about each item be available from the financial statements? Explain your...
-
Sean McNama is a renowned medical researcher at a large Canadian university. For many years he has been working on a technology that could significantly improve the vision of visually impaired...
-
Perfect competition is a market structure involving a(n) _________ number of buyers and sellers, a(n) _________ product, and _________ market entry and exit.
-
Because of _________ market entry and exit, perfectly competitive markets generally consist of a(n) _________ number of small suppliers.
-
Because perfectly competitive markets have _________ buyers and sellers, each firm is so _________ in relation to the industry that its production decisions have no impact on the market.
Study smarter with the SolutionInn App