Based on the information below, you are to prepare all operations budgets, financial budgets and schedules...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Based on the information below, you are to prepare all operations budgets, financial budgets and schedules for a bicycle manufacturer. Wing Bicycle Company manufactures and sells 2 sizes of bicycles, 21.5 inch and 22.5 inch. Sales - Their sales team has committed to the following projected monthly unit sales for the next year. Nov Dec Jul Sep Oct Aug 317 Jun Apr 616 Jan Feb Mar May 345 322 317 317 328 420 368 472 633 443 21.5 Bike 535 385 300 280 275 275 275 285 365 22.5 Bike 320 410 550 The selling price for the 21.5 inch bike is $455. For the 22.5 inch bike it is $490. The desired ending inventory for each month is 15% of the following month's sales for the 21.5 inch bike and 12% for the 22.5 inch bike. The Inventory at January 1 of the budget year is expected to be 55 units of the 21.5 inch bike and 38 units of the 22.5 inch bike. The projected sales for Jan of the year following the budget are 385 of the 21.5 inch bike and 350 for the 22.5 inch bike. Materials - The total materials for the 21.5 inch bike and 22.5 inch bike are $164.45 and $186.30 respectively (Bill of Materials in workbook for information purposes). The production department would like to have an ending raw materials inventory of 20% of the next month's production requirements. Desired ending production inventory for December is $15,700 for 21.5 inch bike and $15,300 for 22.5 inch bike. Beginning raw materials inventory value for Jan of the budget year are $16,370 for the 21.5 inch bike and $18,597 for the 22.5 inch bike. Direct Labor - Direct labor is 3.9 hours at $15.25 per hour for the 21.5 inch bike and 4.4 hours at $15.25 per hour for the 22.5 inch bike (Process sheet in workbook for information purposes). Manufacturing Overhead - Manufacturing overhead is based on direct labor hours at a rate of $22.25 per DLH for each of the bikes. Budgeted monthly fixed overhead is as follows: 5,000 2,200 Salaries Utilities Depreciation 7.200 2,800 2,000 Maintenance Insurance Property Taxes 1,200 Sales, General & Administrative - Sales, General and Administrative (SG&A) expenses are based on unit sales for variable expenses at $11.20 per unit. Fixed SG&A expenses are $18,000 per month, Part of these SG&A expenses are non-cash and amount to $7,800 per month. Cash - Cash is expected to be collected at 55% of the prior month sales and 45% of the sales from 2 months prior. Nov/Dec sales for the prior year are $422,000 and $475,000 respectively. Monthly cash disbursements for materials are 50% of current month's purchases and 50% of last month's purchases. Trade accounts payable should be based on materials purchases and the balance at Dec 31 of the year prior to the budget year is estimated to be $42,000, Assume all other expenses are paid in the month incurred. The beginning cash balance for Jan of the budget year is estimated to be $ 39,979, The company has estimated balance sheet amounts as of Jan 1 of $225,000 for Land, $1.280,000 for Property, Plant & Equipment, $2,125,000 for Common Stock and Retained Earnings of $510,915. Bepihning Cash Collected 100N Feb Mar May Aut Nov Dec Jan %of Prior Manth 1 Sales Nof Prior Munth 3 Sales Sales Cash Collected I Mort Aer Sale 2 Monthe Aher Sale Total Cash Collected Accounts Recaivale (KsH DISBURLEMENTS (matavialss N MenthN Mh Fe Mu teer Ar aha ihaie APunh Tete Maritnh di fe 13 UDGHT len Fel Mar Apr May Jun Sep Oct Beganng nce Nov Dec Total Ad Cash Cotecton Total Cash Avlae Les Cash Dubursements Mater Oivect Labor Manufacturing Overtead SGAA fatal Dbursements tnding Cash ano Based on the information below, you are to prepare all operations budgets, financial budgets and schedules for a bicycle manufacturer. Wing Bicycle Company manufactures and sells 2 sizes of bicycles, 21.5 inch and 22.5 inch. Sales - Their sales team has committed to the following projected monthly unit sales for the next year. Nov Dec Jul Sep Oct Aug 317 Jun Apr 616 Jan Feb Mar May 345 322 317 317 328 420 368 472 633 443 21.5 Bike 535 385 300 280 275 275 275 285 365 22.5 Bike 320 410 550 The selling price for the 21.5 inch bike is $455. For the 22.5 inch bike it is $490. The desired ending inventory for each month is 15% of the following month's sales for the 21.5 inch bike and 12% for the 22.5 inch bike. The Inventory at January 1 of the budget year is expected to be 55 units of the 21.5 inch bike and 38 units of the 22.5 inch bike. The projected sales for Jan of the year following the budget are 385 of the 21.5 inch bike and 350 for the 22.5 inch bike. Materials - The total materials for the 21.5 inch bike and 22.5 inch bike are $164.45 and $186.30 respectively (Bill of Materials in workbook for information purposes). The production department would like to have an ending raw materials inventory of 20% of the next month's production requirements. Desired ending production inventory for December is $15,700 for 21.5 inch bike and $15,300 for 22.5 inch bike. Beginning raw materials inventory value for Jan of the budget year are $16,370 for the 21.5 inch bike and $18,597 for the 22.5 inch bike. Direct Labor - Direct labor is 3.9 hours at $15.25 per hour for the 21.5 inch bike and 4.4 hours at $15.25 per hour for the 22.5 inch bike (Process sheet in workbook for information purposes). Manufacturing Overhead - Manufacturing overhead is based on direct labor hours at a rate of $22.25 per DLH for each of the bikes. Budgeted monthly fixed overhead is as follows: 5,000 2,200 Salaries Utilities Depreciation 7.200 2,800 2,000 Maintenance Insurance Property Taxes 1,200 Sales, General & Administrative - Sales, General and Administrative (SG&A) expenses are based on unit sales for variable expenses at $11.20 per unit. Fixed SG&A expenses are $18,000 per month, Part of these SG&A expenses are non-cash and amount to $7,800 per month. Cash - Cash is expected to be collected at 55% of the prior month sales and 45% of the sales from 2 months prior. Nov/Dec sales for the prior year are $422,000 and $475,000 respectively. Monthly cash disbursements for materials are 50% of current month's purchases and 50% of last month's purchases. Trade accounts payable should be based on materials purchases and the balance at Dec 31 of the year prior to the budget year is estimated to be $42,000, Assume all other expenses are paid in the month incurred. The beginning cash balance for Jan of the budget year is estimated to be $ 39,979, The company has estimated balance sheet amounts as of Jan 1 of $225,000 for Land, $1.280,000 for Property, Plant & Equipment, $2,125,000 for Common Stock and Retained Earnings of $510,915. Bepihning Cash Collected 100N Feb Mar May Aut Nov Dec Jan %of Prior Manth 1 Sales Nof Prior Munth 3 Sales Sales Cash Collected I Mort Aer Sale 2 Monthe Aher Sale Total Cash Collected Accounts Recaivale (KsH DISBURLEMENTS (matavialss N MenthN Mh Fe Mu teer Ar aha ihaie APunh Tete Maritnh di fe 13 UDGHT len Fel Mar Apr May Jun Sep Oct Beganng nce Nov Dec Total Ad Cash Cotecton Total Cash Avlae Les Cash Dubursements Mater Oivect Labor Manufacturing Overtead SGAA fatal Dbursements tnding Cash ano
Expert Answer:
Answer rating: 100% (QA)
1 Sales Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct No... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Based on the information in Tables A, B, C, D, and E, develop training materials for entry-level marketing professionals (specifically those working for a company whose target segment is or includes...
-
Based on the information you gathered in your process identification assignment in Unit 1, you selected a process to carry forward through the remainder of your Operations Improvement Plan (OIP)...
-
Based on the information collected in Question 22, how practical would it be to encourage foreign sales? Your average order ranges from about $250 to $800. All prices are quoted plus shipping and...
-
Use the data in Exercise 13.28.To familiarize yourself with recursive least squares, estimate the savings functions for 19701981, 19701985, 19701990, and 19701995. Comment on the stability of...
-
American Airlines is interested in the proportion of flights that are full during the 2008 summer season. The airline uses data from past experience and constructs the following prior distribution of...
-
The speed of light in topaz is 1.85 108 m/s. What is the index of refraction of topaz?
-
For each of the following situations, calculate the \(t\)-statistic \((t)\) : a. \(\mathrm{X}^{-}=4.00 ; \mu=5 ; s=3.00 ; N=36\) b. \(\mathrm{X}^{-}=1.50 ; \mu=1.25 ; s=.75 ; N=25\) c....
-
Mystic Herbals processes exotic plant materials into various fragrances and biological pastes used by perfume and cosmetic firms. One particular plant material, Xubonic root from the rain forest in...
-
ABC firm has a ROA of 15%, Net Profit Margin of 2% and ROE of 19%. What is its Equity Multiplier?
-
To: [Your name] From: Supervising Attorney Re: United States v. Canter; armed bank robbery with a dangerous weapon We have been appointed to represent Eldon Canter in the case of United States v....
-
A company has been improving its organizational security and compliance program since the last security review was conducted one year ago. What should the company do to evaluate its current risk...
-
We understand through confidential sources that PCS is for sale for $1,750,000. Should Webster Hospital purchase PCS? Note that our hurdle rate is 6 percent. What is the maximum price Webster...
-
A company purchased $11,600 of merchandise on June 15 with terms of 3/10, n/45, and FOB shipping point. The freight charge, $1300, was added to the invoice amount. On June 20, it returned $2080 of...
-
Company XYZ has hired investment bankers to help raise capital for its investment projects for next year. Given this situation, shall the company use the historical cost of capital or the marginal...
-
C1. For each meeting planned in Section 1, prepare a visual/written presentation that reflects the information requirements and desired outcomes outlined in the work you've done on this assessment so...
-
Recall that one of the Sampsons' goals is to invest for their children's future college education. They are considering investing in several stocks that are rated highly by analysts. Offer advice to...
-
How to Turn a Lack of Cultural Intelligence Into Cultural Sensitivity (From Regional Star to Global Leader) The Inciting Incident This case study follows the journey of a French fragrance company...
-
Identify the source of funds within Micro Credit? How does this differ from traditional sources of financing? What internal and external governance mechanisms are in place in Micro Credit?
-
Denise received a modest inheritance from a great aunt and wants to use it to buy a small business. Her problem is that she just doesnt have the first idea how to go about finding a business to buy....
-
Suppose you are in the business of making ladders. A customer places a board plank between two of your ladders as a scaffold. One of the ladders fails, causing your customer to fall and break a leg....
-
What are the three situations where it might make more sense to go into business part-time rather than full-time?
-
An inborn error of metabolism is caused by a. a mutation in a gene that causes an enzyme to be inactive. b. a mutation in a gene that occurs in somatic cells. c. the consumption of foods that disrupt...
-
During the initiation stage of translation in bacteria, which of the following events occur(s)? a. IF1 and IF3 bind to the 30S subunit. b. The mRNA binds to the 30S subunit, and tRNAfMet binds to the...
-
Each ribosomal subunit is composed of a. multiple proteins. c. tRNA. b. rRNA. d. both a and b.
Study smarter with the SolutionInn App