Answered step by step
Verified Expert Solution
Question
1 Approved Answer
D Tunes is a ballroom studio in Pocatello, Idaho. The studio's owner has collected data regarding the studio's sales for lessons in January 2025 .
D Tunes is a ballroom studio in Pocatello, Idaho. The studio's owner has collected data regarding the studio's sales for lessons in January 2025 . You are interning with them as an accountant. The owner has a series of questions that can be answered using data that has already been given to you. You have already developed the data dictionary and the data model for the data set. D*Tunes Data Dictionary Students \begin{tabular}{ll} \hline Column Name & Field Description \\ \hline StudentID & An ID that uniquely identifles a student. \\ \hline StudentName & A student's name. \\ \hline Level & Student's Skill Level: \\ & B= Beginner \\ & I= Intermediate \\ & A= Advanced \\ \hline Gender & A student's gender. \\ \hline \end{tabular} Lessons \begin{tabular}{ll} \hline Column Name & Field Description \\ \hline LessonID & An ID that uniquely identifles a lesson. \\ \hline Date & The date on which the lesson occurred. \\ \hline Class & The type of class taught during this lesson. \\ \hline Instructor & The ID of the instructor teaching this class. \\ \hline \end{tabular} Participates Column Name Field Description Lesson The ID of the lesson taken by the student. Student The ID of the student taking the lesson. KeyColumnForeignkey For the two salaried employees, D Tunes must withhold the employer portion of FICA taxes every month from their wages. FICA tax is a combination of Social Security tax and Medicare tax. The 2025 FICA tax rate is 7.65\%, which includes Social Security tax of 6.2\% and Medicare tax of 1.45%. The owner does not need to withhold Social Security tax for any earnings above $168,900. Therefore, the studio must only withhold Medicare tax on wages above this amount. Create an information model that will allow you to design a worksheet similar to the one shown that will help the studio determine the FICA tax payments for each month. Upload a Word file that includes your analysis and answers and an Excel file with your calculations. D Tunes is a ballroom studio in Pocatello, Idaho. The studio's owner has collected data regarding the studio's sales for lessons in January 2025 . You are interning with them as an accountant. The owner has a series of questions that can be answered using data that has already been given to you. You have already developed the data dictionary and the data model for the data set. D*Tunes Data Dictionary Students \begin{tabular}{ll} \hline Column Name & Field Description \\ \hline StudentID & An ID that uniquely identifles a student. \\ \hline StudentName & A student's name. \\ \hline Level & Student's Skill Level: \\ & B= Beginner \\ & I= Intermediate \\ & A= Advanced \\ \hline Gender & A student's gender. \\ \hline \end{tabular} Lessons \begin{tabular}{ll} \hline Column Name & Field Description \\ \hline LessonID & An ID that uniquely identifles a lesson. \\ \hline Date & The date on which the lesson occurred. \\ \hline Class & The type of class taught during this lesson. \\ \hline Instructor & The ID of the instructor teaching this class. \\ \hline \end{tabular} Participates Column Name Field Description Lesson The ID of the lesson taken by the student. Student The ID of the student taking the lesson. KeyColumnForeignkey For the two salaried employees, D Tunes must withhold the employer portion of FICA taxes every month from their wages. FICA tax is a combination of Social Security tax and Medicare tax. The 2025 FICA tax rate is 7.65\%, which includes Social Security tax of 6.2\% and Medicare tax of 1.45%. The owner does not need to withhold Social Security tax for any earnings above $168,900. Therefore, the studio must only withhold Medicare tax on wages above this amount. Create an information model that will allow you to design a worksheet similar to the one shown that will help the studio determine the FICA tax payments for each month. Upload a Word file that includes your analysis and answers and an Excel file with your calculations
Step 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