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
-
Consider the following set of activities: a. Draw the CPM network for this problem. (Remember that a CPM network requires unique start and finish nodes.) b. Manually determine the earliest and latest...
-
An article in the New York Times, published September 29, 2008, and titled "Study Finds Association between Hepatitis B and Pancreatic Cancer," reported that, for the first time, a study showed that...
-
Apply capital budgeting to a current event (Learning Objective 1) Look through the business section of the newspaper. Find a company that has recently made a capital investment. Summarize the...
-
MSI is considering eliminating a product from its Toddle Town Tours collection. This collection is aimed at children one to three years of age and includes "tours" of a hypothetical town. Two...
-
The adjusted trial balance for Tybalt Construction on December 3 1 of the current year follows. \ table [ [ , \ table [ [ TYBALT CONSTRUCTION ] , [ Adjusted Trial Balance ] , [ December 3 1 ] ] , , ]...
-
On December 31, 2020, Helena Company, a California real estate firm, received two $18,000 notes from customers in exchange for services rendered. The 8% note from El Dorado Company is due in nine...
-
Jasha, age 45, meets with his insurance agent, Byron, to discuss an investment strategy. Jasha plans to borrow $100,000 from his bank in order to purchase a portfolio of non-registered segregated...
-
Comfort Manufacturing is a small textile manufacturer using machine-hours as the single indirect-cost rate to allocate manufacturing overhead costs to the various jobs contracted during the year. The...
-
Evaluate the changing role of managers and the importance of partnership between management and human resources. What are 3 more (separate) ways that aren't already mentioned, you think the HR...
-
2. (a) In the context of Object Oriented Analysis and Design, when designing the structural model, what are the implications of designing a bi-directional association between two classes in terms of...
-
Your agile team spends a lot of time creating User Stories. These are small batches of work which are intended to be delivered in one Sprint. To save time, your manager asks you to create one big...
-
What support and contributions do nonprofits add to work of elected officials and public organizations? For what reasons would you encourage local organizations to become involved in policy-making
-
Which Amendment of the United States Constitution prohibits searches conducted outside the judicial process without prior approval? 1st 4th 5th 8th
-
The words without recourse on an indorsement means the indorser is: a. not liable for any problems associated with the instrument. b. not liable if the instrument is dishonored. c. liable personally...
-
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...
-
The following information relates to Karin Weigel Co. for the year 2006. Instructions After analyzing the data, prepare an income statement and a retained earnings statement for the year ending...
-
Griswold Inc.. a public camping ground near the Boundary Waters Canoe Area, has compiled the following financial information as of December 31. 2006. Instructions (a) Determine Griswold's net income...
-
Lynn Close is the bookkeeper for Sanculi Company. Lynn has been trying to get the balance sheet of Sanculi Company to balance. Sanculi's balance sheet is as follows. Instructions Prepare a correct...
Study smarter with the SolutionInn App