Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I'm struggling to finish this review assignment. I understand it's a lot and if it's easier to do it on an excel spreadsheet that is
I'm struggling to finish this review assignment. I understand it's a lot and if it's easier to do it on an excel spreadsheet that is fine
Excel Group Project DUE: November 18, 2015 GROUP MEMBERS: PROBLEM Optima Company is a high-technology organization that produces a mass-storage system. The design of Optima's system is unique and represents a breakthrough in the industry. The units Optima produces combine positive features of both compact and hard disks. The company is completing its fifth year of operations and is preparing to build its master budget for the coming year (2014). The budget will detail each quarter's activity and the activity for the year in total. The master budget will be based on the following information a. Fourth-quarter sales for 2013 are 55,000 units. b. Unit sales by quarter (for 2014) are projected as follows 2014 Projected Sales Units First-quarter Second-quarter Third-quarter Fourth-quarter 65,000 70,000 75,000 90,000 $400 fall are credit sales Selling price per unit Collections: 85% within the sales quarter 15% in the following quarter c. FG Inventory: There is no beginning inventory of finished goods. Optima is planning the following ending finished goods inventories for each quarter FG Inventory-Planned Ending Units Balance First-quarter Second-quarter Third-quarter Fourth-quarter 15,000 20,000 d. Each mass-storage units uses: Prime Costlnput used Cost/Input Direct Labor (hours Direct material $10 $50 $240 e. DM Inventory: There are 65,700 units of direct materials in the beginning inventory as of January 1,2014. At end of the quarter, Optima plans to have 30% of the direct materials needed for the next quarter's unit sales. Optima will end the year with the same amount of direct materials found in this year's beginning Balance Jan 1, 2014 nding Bal each quarter Bal of next quarters unit sales same as this year's beginning inventoStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started