Hillary wants to use Excel to export data as an XML file. She first inserts all of her data into Excel. Then she creates a schema and saves it as an XSD file. Hillary then opens Excel and begins working, using the Developer tab to export her Excel data. Which steps must Hilary perform before she can export the data? She must add the schema to Excel, and then she must map the elements from the tree onto the worksheet.

She must map the elements from the tree onto the worksheet, and then she must add the schema.

She must import the XML file, and then she must add the schema to the Excel file.

She must add the schema to the Excel file, and then she must import the XML file.

Dollywood corporation accumulates the following data concerning a mixed cost, using miles as the activity level. miles driven total cost january 10,000 $16,500 february 8,000 $14,500 march 9,000 $12,500 april 7,000 $12,000 compute the variable and fixed cost elements using the high-low method

Accublade castings inc. casts blades for turbine engines. within the casting department, alloy is first melted in a crucible, then poured into molds to produce the castings. on may 1, there were 230 pounds of alloy in process, which were 60% complete as to conversion. the work in process balance for these 230 pounds was $32,844, determined as follows: exercises during may, the casting department was charged $350,000 for 2,500 pounds of alloy and $19,840 for direct labor. factory overhead is applied to the department at a rate of 150% of direct labor. the department transferred out 2,530 pounds of finished castings to the machining department. the may 31 inventory in process was 44% complete as to conversion. prepare the following may journal entries for the casting department: the materials charged to production the conversion costs charged to production the completed production transferred to the machining department determine the work in process"casting department may 31 balance.

Afinancial institution, the thriftem bank, is in the process of formulating its loan policy for the next quarter. a total of $12 million is allocated for that purpose. being a full-service facility, the bank is obligated to grant loans to different clientele. the following table provides the types of loans, the interest rate charged by the bank, and the possibility of bad debt as estimated from past experience.type of loaninterest rateprobability of bad debtpersonal.140.10car.130.07home.120.03farm.125.05commercial.100.02 bad debts are assumed unrecoverable and hence produce no interest revenue either. competition with other financial institutions in the area requires that the bank allocate at least 40% of the total funds to farm and commercial loans. to assist the housing industry in the region, home loans must equal at least 50% of the personal, car, and home loans. the bank also has a stated policy specifying that the overall ratio for bad debts on all loans may not exceed .04. formulate this problem as a linear program. define your variables clearly and write all the constraints explaining the significance of each.