Excel McGraw Hill Excel Question - Saved VDuA1FileTag:Home1112✓Insert10 Required:Calibri✓ADrawData Review ViewB田くふく AEv abGeneral2、fx Accessibility tab summary: Two data tables for Miami Solar are presented in cells G2 to H4 and G6 to J8. A statement of requirement is presented in rows 10 to 13 anBCDEFGHK McGraw Hill12 Miami Solar manufactures solar panels for industrial use. The company budgets production of 5,000units (solar panels) in July and 5,300 units in August.Formulas✓11Prepare the direct materials budget for July.Each unit requires 3 pounds of direct materials, which cost $6 per pound. The company's policy is tomaintain direct materials inventory equal to 30% of the next month's direct materials requirement. Asof June 30, the company has 4,500 pounds of direct materials in inventory.2122 Total materials required (pounds)MIAMI SOLARDirect Materials Budget2324 Materials to be purchased (pounds)2526 Cost of direct materials purchases27O Search (Option + Q)V***▼HelpJulyEditing ✓Units ProducedJuly5,000Pounds perunit(Use cells A2 to J8 from the given information to complete this question. Negative amounts or amounts to be deducted should be input and13 displayed as negative values.)1415161718 Units to produce1920 Materials needed for production (pounds)3August5,300I$640.00Cost per Materials June 30requirement inventory4,500pound30%J.00Your timed assigstill counting dowmuch time you hclick on your origassignment tab.Check AnswersCheck My Work3LegendGraded cell: Leave-needed.Scratchpad: Use asworkspaceSave and Return

In order to satisfy the needs of the production budget, the direct materials budget computes the…

2 Miami Solar manufactures solar panels for industrial use. The company budgets production of 5,000 units (solar panels) in July and 5,300 units in August. 3 4 5 6 Each unit requires 3 pounds of direct materials, which cost $6 per pound. The company's policy is to 7 maintain direct materials inventory equal to 30% of the next month's direct materials requirement. As of June 30, the company has 4,500 pounds of direct materials in inventory. 8 9 10 Required: 11 Prepare the direct materials budget for July. 12 Units Produced July 5,000 Pounds per unit 3 August 5,300 Cost per pound $6 Materials requirement 30% June 30 inventory 4,500

2 Miami Solar manufactures solar panels for industrial use. The company budgets production of 5,000 units (solar panels) in July and 5,300 units in August. 3 4 5 6 Each unit requires 3 pounds of direct materials, which cost $6 per pound. The company's policy is to 7 maintain direct materials inventory equal to 30% of the next month's direct materials requirement. As of June 30, the company has 4,500 pounds of direct materials in inventory. 8 9 10 Required: 11 Prepare the direct materials budget for July. 12 Units Produced July 5,000 Pounds per unit 3 August 5,300 Cost per pound $6 Materials requirement 30% June 30 inventory 4,500

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

eBook Question Content Area Extreme Sports sells logo sports merchandise. The company is contemplating whether or not to continue its custom embroidery service. All of the company’s direct fixed costs can be avoided if a segment is dropped. The information is available for the segments. CustomEmbroidery LogoApparel Sales $60,000 $250,000 Variable costs 29,000 110,000 Contribution margin $31,000 $140,000 Direct fixed costs 22,000 39,000 Allocated common fixed costs 13,000 49,000 Net income $(4,000) $52,000 A. What will be the impact on net income if the embroidery segment is dropped? Net income $fill in the blank 1 B. Assume that if the embroidery segment is dropped, apparel sales will increase 10%. What is the impact on the contribution margin and net income solely for the apparel? Contribution margin $fill in the blank 3 Net income $fill in the blank 5 C. Identify one cost that is…
Answer complete question please please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image) The Foundational 15 (Algo) [LO11-2, LO11-3, LO11-4, LO11-5, LO11-6] Skip to question [The following information applies to the questions displayed below.] Cane Company manufactures two products called Alpha and Beta that sell for $175 and $135, respectively. Each product uses only one type of raw material that costs $5 per pound. The company has the capacity to annually produce 117,000 units of each product. Its average cost per unit for each product at this level of activity are given below: Alpha Beta Direct materials $ 40 $ 15 Direct labor 30 30 Variable manufacturing overhead 18 16 Traceable fixed manufacturing overhead 26 29 Variable selling expenses 23 19 Common fixed expenses 26 21 Total cost per unit $ 163 $…
The Reward One Company manufactures windows. Its manufacturing plant has the capacity to produce 12,000 windows each month. Current production and sales are 10,000 windows per month. The company normally charges $250 per window. Requirement 1. Should Reward One accept this special order? Show your calculations. Begin by completing an analysis, and start by showing the computation of the company's operating income without the special order. Next, calculate operating income with the special order, and then calculate the differences between the two columns. (Complete all input fields. For amounts with no change, make sure to enter "0" in the appropriate cells of the Difference column.) Variable costs that vary with number of units produced Direct materials $600,000 Direct manufacturing labor 700,000 Variable costs (for setups, materials handling, quality control, and so on) that vary with number of batches, 100 batches × $1,500 per batch…
u messageQ&A notifications account_circle Business AccountingQ&A LibraryAn operations manager narrowed the search for a new facility location to four communities. The annual fixed costs (land, property taxes, insurance, equipment, and buildings) and the variable costs (labor, materials, transportation, and variable overhead) are as follows:Community Fixed Costs per Year Variable Costs per UnitA $150,000 $62B $300,000 $38C $500,000 $24D $600,000 $30Notice that no community dominates the set of alternatives; that is, no community has both the lowest fixed costs and the lowest variable costs per unit. If that were so, that community would be the best location.Step 1. Plot the total cost curves for all the communities on a single graph. Identify on the graph the approximate volume range…
f. Short-Term Product-Mix Decision DVD Production Company produces two basic types ofvideo games, Flash and Clash. Pertinent data for DVD Production Company follow:*Based on direct labor hours: 4 direct labor hours (DLHs) per unit of Flash and 2 DLHs perunit of Clash.Flash ClashSales price $250 $140CostsDirect materials 50 25Direct labor (@ $25/hr.) 100 50Variable factory overhead* 50 25Fixed factory overhead* 20 10Marketing costs (all fixed) 10 10Total costs $230 $120Operating profit $ 20 $ 20The DVD game craze is at its height so that either Flash or Clash alone can be sold to keep the plantoperating at full capacity. However, labor capacity in the plant is insufficient to meet the combineddemand for both games. Flash and Clash are processed through the same production departments.Required1. What is the meaning and importance of the statement that “Flash and Clash are processed through thesame production departments”?
ASK MATH SOLVER FIND Principles of Accounting Volume 2 19th Edition ISBN: 9781947172609 Author: OpenStax Publisher: OpenStax College bookmark_border expand_more Chapter 5 : Process Costing expand_more Section: Chapter Questions format_list_bulleted Problem 1PB: The following product costs are available for Stellis Company on the production of erasers: direct... See similar textbooks Question Transcribed Image Text:Orion Ic., is a newly organized manufacturing business that plans to manufacture and sell 30,000 units per year of a new product. The following estimates have been made of the company's costs and expenses (other than income taxes): Variable Fixed per Unit Manufacturing costs: Direct materials........... Direct labor... Manufacturing overhead...$440,000 $ 38 47 Period costs: Selling expenses.... Administrative expenses. ..... 360,000 $800,000 $100 Totals ... a. What should the…
Instructions for Excel Spreadsheet Assignment #2Preliminary Setup InformationYour company manufactures and sells computer memory chips. You are part of the department whose job it is to figure out how many chips you should produce and sell. Let x represent the number (in millions) of chips that you plan to produce and sell. Your marketing department has figured out that if you produce x million chips then the selling price (in dollars) you must charge for each chip is given by the functionp(x) = 150-2x. Your production department has figured out that if you produce x million chips then the cost of production (in millions of dollars) will be given by the function C(x) = 50 + 40xYour tax department has figured out that you should expect to pay 10% tax on any profits. The tax (in millions of dollars) on a profit of y millions of dollars will be given by the functionT( y) = 0.1yExplanation of what you are to do on the Excel spreadsheetNOTE: You will not get credit for your work if you just…
Choose the correct letter of answer The company’s available number of hours to produce 15,000 units for products x and y are 500 hours only. For this situation, which mathematical model is appropriate to express such a constraint? *a. x + y ≥ 15,000b. x + y ≤ 15,000c. x + y ≤ 500d. x + y ≥ 500
Q5b) Contribution statement for Chiyeyeye furniture manufacturing LtdProduct A(ZMW) Product B(ZMW)Sales 1000 500Variable costs 600 300Contribution 400 200Fixed costs 200 200Profit 100 -Calculatei) Break-even point for each productii) Contribution ratio for each productiii) Can you close product B and why? Explain
CD Only CD With Instructional Materials Estimated Demand 43,000 Units 43,000 Units Est. Sales Price $27.000 $54.00 Est. Cost per unit Dir. Materials $2.50 $2.75 Dir. Labor $3.00 $6.00 Var. Manufacturing OH $3.00 $6.25 Fixed Man. OH $3.00 $3.00 Unit Man. Cost $11.50 $18.00 Additional Development Cost $125,000 Based on the given data, compute the increase or decrease in profit that would result if instructional materials were added to the CD's.…
eneral Mathematics SHSModule 41What I Can DoYou wanted to join a booth fair, and you are aiming to get a profit that is twice as your capital. Your starting capital is ₱15,000.00. Make a financial plan for the booth that you will set up and the product that you will sell. You may use the sample planbelow:FINANCIAL PLANProduct: _________________________Description of product: ________________________Goal: _____________________________________Capital: ₱15,000.00Fixed Cost (Labor, Machineries, Expenses for the booth etc): _______Variable Cost (Materials, Ingredients, etc): ____________Profit function: ___________________Prove that profit function will yield an amount that is twice the capital______________________________________________________________________________________
A Sushi Kiosk in the Philippines PESTLE (Political, Economic, Sociocultural, Technological, Legal, Environmental) analysis Identify only areas/forces with direct and significant impact on the company Startup costs (one-time payment) Business registration 5,915.00 Other legal certification requirements 500.00 Other expenses: technology /equipment needed for production Total startup cost xxx Operating costs (good for 1 year, base this on your monthly OC and just multiply it by 12) Rental Utilities Raw materials Others: marketing activities Total operating cost xxx Total Funding Requirement xxx Sources of Funds (minimum of 7 sentences) Competitor Analysis (minimum of 7 sentences) Note: Location is Philippines Davao. The currency should be the philippine peso